NEED 30 -31 days for data for each month.

J

Jay

I've been tasked with finding a method for creating a thirty day data entry
spread sheet tool which will take, report and display 30 - 31 days of data.
Any one know of a simple method for doing this?

There will be 165 employees, which will need to enter daily data for their
daily activity, which managment wants to monitor. So, it will be equal to 165
X 365 days. Is this even recommended? Or should I suggest using a Access
database, instead? 'Cause Excel, I don't think, will be able to handle this
too well, will it?
 
B

Bob Phillips

Sounds simple

In B1, enter 1, C1 enter 2, then copy them across to AF
In A2:A166 enter the employees names.

You then have a grid for the data.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
D

Duke Carey

Doing what you're talking about and maintaining all the different input
sheets in Excel sounds like a full-time, stress-inducing, thankless task.

About 18 months ago I did some checking for time & billing software for a
small group. Though I can't remember any of the product names now, I found
several reasonably priced packages that sounds like they'd do very much what
you would like. They were all web based, so you could run them on your
intranet

Barring that, then yes, use Access or a VB.Net front end to SQL Server
 
Top