View Single Post
  #1   Report Post  
Lauren qt314
 
Posts: n/a
Default Macro to add numbers to create combinations that equal certain amo

Thank you for your assistance.

I receive a list of numbers, usually over one hundred items. I need to find
out which amounts will add up to a given total. How would I create a macro
to do this? Is there already an Excel function to do this that I have not
found? It would need to work with currency.

Ex: 9, 12, 7, 4, 15, 8, 10, 3 total needed 18
Solution 8+10; 3+15