You could use Data|Subtotals (xl2003 menus) and keep the data and the subtotals
on the same sheet.

You'll be able to hide the details by using the outlining symbols at the left.

You could even hide the details, select the range to copy (just the visible
cells) and paste special to the new worksheet -- but why bother????

Another option is to learn about pivottables. They would do what you ask (as a
separate sheet).

If you've never used pivottables, here are a few links:

Debra Dalgleish's pictures at Jon Peltier's site:
http://peltiertech.com/Excel/Pivots/pivottables.htm
And Debra's own site:
http://www.contextures.com/xlPivot01.html

John Walkenbach also has some at:
http://j-walk.com/ss/excel/files/general.htm
(look for Tony Gwynn's Hit Database)

Chip Pearson keeps Harald Staff's notes at:
http://www.cpearson.com/excel/pivots.htm

MS has some at (xl2000 and xl2002):
http://office.microsoft.com/downloads/2000/XCrtPiv.aspx
http://office.microsoft.com/assistan...lconPT101.aspx


George wrote:

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

--

Dave Peterson