Hi All,
I have a datasheet which have 2 columns Col 1 has Customers name and Col 2 has been the cost spent by him. e.g.
Col 1 Row 1: Cathy Col 2 Row 1: 34
Col 1 Row 2: Cathy Col 2 Row 2: 0
Col 1 Row 3: Cathy Col 2 Row 3: -9
Col 1 Row 4: Cathy Col 2 Row 4:
Col 1 Row 5: James Col 2 Row 5:
Col 1 Row 6: Mike Col 2 Row 6: 30
Col 1 Row 7: Mike Col 2 Row 7: 20
and so on.....
I need a macro which takes all the name put it in another sheet with total amount sent. e.g. in 2nd sheet it should look like:
Col 1 Row 1: Cathy Col 2 Row 1: 25
Col 1 Row 2: James Col 2 Row 2:
Col 1 Row 3: Mike Col 2 Row 3: 50
The values which are not present should remain blank only and 0 should not be put there.
I hope I have made clear myself but if you have any questions please revert.
Thanks to all of you in advance!!!!
I have a datasheet which have 2 columns Col 1 has Customers name and Col 2 has been the cost spent by him. e.g.
Col 1 Row 1: Cathy Col 2 Row 1: 34
Col 1 Row 2: Cathy Col 2 Row 2: 0
Col 1 Row 3: Cathy Col 2 Row 3: -9
Col 1 Row 4: Cathy Col 2 Row 4:
Col 1 Row 5: James Col 2 Row 5:
Col 1 Row 6: Mike Col 2 Row 6: 30
Col 1 Row 7: Mike Col 2 Row 7: 20
and so on.....
I need a macro which takes all the name put it in another sheet with total amount sent. e.g. in 2nd sheet it should look like:
Col 1 Row 1: Cathy Col 2 Row 1: 25
Col 1 Row 2: James Col 2 Row 2:
Col 1 Row 3: Mike Col 2 Row 3: 50
The values which are not present should remain blank only and 0 should not be put there.
I hope I have made clear myself but if you have any questions please revert.
Thanks to all of you in advance!!!!