How do I search thr'o column and put unique values in differnt sheet and
sum corresponding values in different column?

For example I have 3 columns in one sheet
from To total
ABC WP 10
ABC ABC 10

My output should looks like this

col from To
ABC 20 20
WP 0 10

thanks in advaced


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Should the output be:

col from To
ABC 20 10
WP 0 10


--
Regards,
Tom Ogilvy

test test wrote in message
...

How do I search thr'o column and put unique values in differnt sheet and
sum corresponding values in different column?

For example I have 3 columns in one sheet
from To total
ABC WP 10
ABC ABC 10

My output should looks like this

col from To
ABC 20 20
WP 0 10

thanks in advaced


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!