Experts, I am wondering if there is code that will find all possible summs from a number.
INvoice = 100
need to apply to any possible combo of summs:
It is similar to Goal Seek in Excel but the numbers from list do not change as they would in Goal Seek.
I can invision this as being a button on a form then a msgbox appears asking for the number and then returns any possible numbers from the list. Or maybe something in Excel would work but dont believe Excel 2k7 has this functionality (maybe 2010 does).