Finding which numbers sum to a value

[UWHusky]

Hello,

I am not sure if this is possible, but I am trying to tie out some data from two sets of data. I have a number in one of the sets of data (let's call it data set one) and I need to see which numbers in data set 2 sum up to it. There are positive and negative numbers in data set 2. I have tried CTRL + 'Click' on data to try to find which numbers in data set 2 add up to the number I am trying to find in data set 1 but there are so many possible combinations that it is taking a long time. Is there any shortcut?

I am using excel 2007.

Thanks a lot for the help and let me know if I am being to vague.

UWHusky

 

[Armando Montes]

See if this helps:
http://www.tushar-mehta.com/excel/templates/match_values/index.html#VBA_multiple_combinations

 

[UWHusky]

Thank you so much! That was a better answer than I was expecting. That macro is going to help me a lot in the future.

UWHusky