You may want to look at using pivottables.

Some tips...

If your list can grow/contract, use a dynamic range that represents the range.
Take a look at Debra Dalgleish's site to read more about it:
http://www.contextures.com/xlNames01.html#Dynamic

If you want to read more about the pivottable stuff, you may want to look at
some 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

"Frank Rudd via OfficeKB.com" wrote:

I'm trying to make a user form that will put data into a worksheet based on a
date. The data covers around 50 people although this will vary. I can make it
put data on the next row, but without having a separate sheet for each day of
the month (each user also has a sheet, and it's already pretty big). I need
totals for each day also, and the only other option I've come up with is to
put the data into tables by date and do a vlookup, although I would like this
to be automated and there would be blank spaces which would throw everything
off. I would REALLY appreciate any help.

--

Dave Peterson