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


"Jay" wrote:

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?