Audax
04-24-2007, 09:35 AM
:hi: Hi Guys
Please somebody can help me?
Assuming I have 2 columns, let's say Column C with 50 names from top to bottom and Column D with 50 Amounts, one to each name. There could be names repeated among the 50 names. I want to create a "Summary", say in column E and F with E containing the names and column F with a Summary of amounts put together according to the names in E. Below an example with 7 names and respectives amounts and the result in Columns E and F.
C D E F
1 Mike 300 Joe 400
2 Tony 600 Mike 675
3 Joe 300 Tony 950
4 Tony 350
5 Mike 125
6 Mike 250
7 Joe 100
Using VBA is there any way to solve this problem?
Thank you
Please somebody can help me?
Assuming I have 2 columns, let's say Column C with 50 names from top to bottom and Column D with 50 Amounts, one to each name. There could be names repeated among the 50 names. I want to create a "Summary", say in column E and F with E containing the names and column F with a Summary of amounts put together according to the names in E. Below an example with 7 names and respectives amounts and the result in Columns E and F.
C D E F
1 Mike 300 Joe 400
2 Tony 600 Mike 675
3 Joe 300 Tony 950
4 Tony 350
5 Mike 125
6 Mike 250
7 Joe 100
Using VBA is there any way to solve this problem?
Thank you