Numbers That Add to a Specified Sum

[pliskers]

I seem to recall having seen a tip or Add-in that allows you to search a range in Excel for values that add to a sum that you specify. If anyone is aware of how this can be accomplished, please post info.

 

[Andrew Poulsom]

If someone points you to the tip or Add-In please let me know so that I can use it in the Challenge of the Month.

http://www.mrexcel.com/challenge.shtml

 

[pliskers]

ATTN Andrew Poulsom

I did find the macro I remembered seeing. I have it in a file called WHATADDSUP, which I'd be happy to share with you if you send me an e mail at PLISKERS@OPTONLINE.NET. If there's any other way you'd like to receive it, let me know via e mail or posting to this board.

Jeff