find unknown values which adds up to some values

**aravindhan_31** · 07-10-2009, 08:02 AM

Hi,

I have some 100 values in Column A:like
1323
2876.02
3910.33
3360.43
2786.28
5458.01
5476.15
92.19
etc..
And in Cell B2 I have a value 49904.66 ( this is summation of some values from column A, but i dont know what are the values contributed to this)

Is there a way in VBA to check what are the values contributing to the value in B2 and highlight the cells in Column A?

Thanks n Regards
Arvind

**aravindhan_31** · 07-10-2009, 08:08 AM

Hi,

The cross post is here: http://www.vbaexpress.com/forum/show...864#post189864

&

http://www.mrexcel.com/forum/showthr...73#post1994673

Thanks
Arvind

**StephenR** · 07-10-2009, 08:14 AM

You could try looking here: http://www.tushar-mehta.com/excel/te...olver_Template

Don't ask me to explain though ...

**aravindhan_31** · 07-16-2009, 12:36 AM

Hi,
Thanks for your help:
The excel solver works for me if I have some 20 - 25 lines and it throws me an error " too many adjustable cells: for 300 line.
I tried with this code. here :
http://www.tek-tips.com/viewthread.cfm?qid=1485698
I entered A2:A300 for input & B2 for target value but I am not getting any result.
I also tried the template from
http://www.tushar-mehta.com/excel/te...olver_Template however it doest not support for 300 lines
the other threads i tired are :
http://www.mrexcel.com/forum/showthread.php?t=22298
http://www.mrexcel.com/pc09.shtml
I am not able to solve the problem. I have attached my file for reference.

help me guys