Total by Name

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

Hello

I am new to using Excel and need help with totalling by name.

I am using VB6 to create a spreadsheet. I am sending 3 columns out
that I need to total the different names of the people submitting
orders.

The program will fille the sheet but I need to break the sheet where
the names stop. ( If this is making sense )

The sheet will start as this

Jeff 8258 01/10/2004
Jeff 9587 01/11/2004
Jeff 9956 01/12/2004
Bill 5478 01/10/2004
Bill 6458 01/11/2004
Bill 7520 01/12/2004
Bill 7912 01/13/2004
Bill 8109 01/14/2004

I would like it to end this way

Jeff 8258 01/10/2004
Jeff 9587 01/11/2004
Jeff 9956 01/12/2004

Total Jeff = 3

Bill 5478 01/10/2004
Bill 6458 01/11/2004
Bill 7520 01/12/2004
Bill 7912 01/13/2004
Bill 8109 01/14/2004

Total Bill = 5

Is this possible?
Thanks
Bob
 
see response in .misc

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top