VBA Question
 

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.

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

Thanks Dave. These are daily performance statistics, and the names change as
new employees are hired or leave the company. It would be great, if possible,
to have vba look in a table based on an entered date, find the name in the
combo box on the user form in that table, and put the information from the
text boxes in the cells to the right of that name. Is that possible? I didn't
know about dynamic ranges, and I can use that in another application I have.
I don't think that will help here though. I don't think a pivot table can be
used in this case either.

--
Message posted via http://www.officekb.com

I bet it could be done.

If you want to learn more about userforms, you can read Debra Dalgleish's site:
http://www.contextures.com/xlUserForm01.html

Maybe using Data|Form would be sufficient, too???

"Frank Rudd via OfficeKB.com" wrote:

Thanks Dave. These are daily performance statistics, and the names change as
new employees are hired or leave the company. It would be great, if possible,
to have vba look in a table based on an entered date, find the name in the
combo box on the user form in that table, and put the information from the
text boxes in the cells to the right of that name. Is that possible? I didn't
know about dynamic ranges, and I can use that in another application I have.
I don't think that will help here though. I don't think a pivot table can be
used in this case either.

--
Message posted via http://www.officekb.com

--

Dave Peterson