I receive a list of numbers. 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

Hi Karlo

You can have a macro to do this to list all the possible combinations.

Do you have format in which the data is currently in.

If this post helps click Yes
---------------
Jacob Skaria

Hi karlo,

See: http://www.tek-tips.com/viewthread.cfm?qid=1485698

--
Cheers
macropod
[MVP - Microsoft Word]


"karlo" wrote in message ...
I receive a list of numbers. 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

Do the figures appear in seperate cells?, do you want the the results in
seperate cells?

karlo;271259 Wrote:
I receive a list of numbers. 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


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=75584

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

Is 3+7+8 a solution also?

= = =
Dana DeLouis


karlo wrote:
I receive a list of numbers. 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

On Mar 16, 8:03*am, Dana DeLouis wrote:
* Ex: 9, 12, 7, 4, 15, 8, 10, 3 * total needed 18
* Solution 8+10; 3+15

Is 3+7+8 a solution also?

= = =
Dana DeLouis



karlo wrote:
I receive a list of numbers. *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- Hide quoted text -

- Show quoted text -

Hi Karlo, check this out:
http://www.geocities.com/excelmx/SumTarget.xls