If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
find sum in list of of numbers
Look he
http://www.mvps.org/dmcritchie/excel/getstarted.htm -- Kind regards, Niek Otten wrote in message oups.com... Wow, thank you so very much for all the responses. I've gone blind looking at these amounts over the past few days so I really appreciate the responses. First off, amongst some of my accountant co workers I know alot about excel but the VBE stuff is a bit shady for me. I've done some macros but the code Mr. Thomlinson provided is a bit out of my league. I'd need a more thorough explanation as to how to set up the code for me to make that work. I pasted it into VBE and turned on those options but I don't know what to do thereafter. I also want to try out the solver option but I need to have it installed. I'll have to try it at work tomorrow morning, man I really didn't expect all these responses this quickly, guess it helps posting in more than one group. For the record it seems that a few of the invoice amounts were missing from my list hence the huge problem with matching them up to payments. Even with that i still have some matching issues. I also forgot to mention that an invoice amount once used when matched to a payment cannot be used again. The combinations of course must match up to the payments to the penny. Again I really would like to try the VBE FindSum program but I'll need some newbie introduction into how to write a code like that and then how to use it. Thanks again! Dza the accountant |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
find sum in list of of numbers | Jim Thomlinson | New Users | 3 | January 4th, 2006 09:58 PM |
Query to find missing numbers | Randy | Running & Setting Up Queries | 3 | December 7th, 2004 10:51 PM |
synchronizing form and list box | Deb Smith | Using Forms | 8 | June 21st, 2004 08:15 PM |
Random Numbers from a List of Numbers | [email protected] | Worksheet Functions | 3 | February 13th, 2004 01:27 AM |
Create a randomly sorted list from selected numbers | Twofingers | Worksheet Functions | 6 | December 31st, 2003 11:49 PM |