VBA to Make Excel Find Combination of Numbers that Equal a Different Number

Hi Everyone

There are times when I have a payment from a customer without reference to what's being paid, and I then need to figure out what the customer is paying based on dollar amount. If I can't figure that out, then I call the customer, but I prefer to find it myself. I'm hoping that one of you fine individuals would be willing to make me a VBA code, assuming this could be done via VBA, to do this math for me.

What I envision is a spreadsheet with three columns. Invoice numbers in A, dollar amounts in B, and the dollar amount I'm looking for in cell C1 or something. This is all editable if you need to move columns around for the code - I don't really care what information is in which column.

What I'm hoping for is that I'll copy paste the invoice numbers and dollar amounts into the sheet, put the dollar amount I'm looking for in C1 (or wherever), and have excel run through every possible combination of adding invoice amounts and highlight the invoices it finds that add up to cell C1, assuming of course that such a combination exists. This could be anywhere from two invoices (rows) to 1,000.

Is this something that VBA can do, and if so, is it something that one of you is willing to create for me?

Thanks for your time!

Take a look at the startSearch Sub here:

http://www.tushar-mehta.com/excel/te.../match_values/

You could put 0 in A1, your payment amount in A2, then all your invoice values in A3:A whatever. After selecting that entire range, run startSearch. It will output all of the possible combos into column B.

I must say this is pretty remarkable code, and all credit for it goes to Tushar Mehta.