Hi Vince
Does your data have column headers? (name etc)
Do you want your sub totalled results on the same sheet, a different
but existing sheet or a new sheet, each time you run the macro?
Do you expect a user to run the macro more than once? If so, do you
want to replace the result of the first run or create a new result?

regards
Paul

"Vince Henschel" wrote in message ...
Ok, but can I set all that up in a workbook to do automatically, that I guess is kind of an important part that I left out - I have to be able to set this up so that people who don't know excel can do this. That is the main reason I thought of using a macro because it can automate the process.

Vince