Timekeeping/Excel
Discussion
This is Excel and business related - so I tossed a coin and posted it here.
I'm trying to make the current timesheet (TS) procedure more efficient.
At present, each member of staff completed a TS and hands/e-mails it to a manager, the manager then manually inputs the details on a master TS to summarise everyones times. A separate master TS is then saved for each day.
I am trying to come up with a way where everyone completes their TS throughout the day in Excel, which at the end of the day would populate the master TS.
The issue is it cannot be done by a copy macro or cell linking (that I can think of). Reason being: if someone does not complete their TS before they leave, but does it the next day instead - it would cock the next day up.
I think I'm looking to be able to tell the master sheet to take a snapshot of all the individuals sheets at the click of a button i.e at the end of the day.
Does that make sense?
If it does and you can make any suggestions you'd make me a happy man!
Cheers
I'm trying to make the current timesheet (TS) procedure more efficient.
At present, each member of staff completed a TS and hands/e-mails it to a manager, the manager then manually inputs the details on a master TS to summarise everyones times. A separate master TS is then saved for each day.
I am trying to come up with a way where everyone completes their TS throughout the day in Excel, which at the end of the day would populate the master TS.
The issue is it cannot be done by a copy macro or cell linking (that I can think of). Reason being: if someone does not complete their TS before they leave, but does it the next day instead - it would cock the next day up.
I think I'm looking to be able to tell the master sheet to take a snapshot of all the individuals sheets at the click of a button i.e at the end of the day.
Does that make sense?
If it does and you can make any suggestions you'd make me a happy man!
Cheers
Gassing Station | Business | Top of Page | What's New | My Stuff