Good Day,

I trying to use VBA to calculate totals in multiple columns when it see
uniques values in another Column..in the example below column "A" contains
user names while columns "B, C, D" contain the values I want totaled based
on the user name in column "A"...An additional thing would be have it place
the values with the user name on a new worksheet.

Col A Col B Col C Col D
John Smith 1.0 1.0 1.0
John Smith 1.25 1.25 2.0
Mary Johnson .75 1.0 2.5
Jack Johnson 1.0 1.0 1.0

The new worksheet would look as follows

Col A Col B Col C Col D
John Smith 2.25 2.25 3.0
Mary Johnson .75 1.0 2.5
Jack Johnson 1.0 1.0 1.0

Thank you in advance for your help
George