aravindhan_3
07-10-2009, 05:04 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?
please find the Cross post is here: http://www.excelforum.com/excel-programming/690959-find-unknown-values-which-adds-up-to-some-values.html#post2125207
Thanks n Regards
Arvind
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?
please find the Cross post is here: http://www.excelforum.com/excel-programming/690959-find-unknown-values-which-adds-up-to-some-values.html#post2125207
Thanks n Regards
Arvind