There’s probably a relatively uncomplicated solution to this, but I’m new to macros don’t know how to pull all the pieces together. I’m trying to create a file that can be used as a timecard for each individual employee to use for punching in and out in real time, while separately creating a record of their in/out times that only a supervisor with password privileges can edit or clear (to prevent employees from altering their own times). I’ve already set up a “Log” worksheet with buttons to punch in/out with the current time (using“= Evaluate("=NOW()")) in multiple in/out columns on a single row that calculates current hours worked (file attached).
Now I want to have these “live” dates and times also logged statically on a second (password-protected) “Log” sheet in the same file. What I have in mind is a row for each day of the month on the “Log” sheet that compares the day of the month in “Log” column D with the date in “Punch” cell E8 and enters the dates and times for that day in the corresponding columns of the “Results” sheet, resulting in a static list of dates and times in and out.
The supervisor would save a copy of the “Results” sheet on a weekly or bi-weekly basis, then clear the dates/times from the original file so that the user can continue to use it without overwriting any needed data from the previous month.
So in short, I’m looking for something that will paste or enter values from one sheet to the other based on the date throughout the month.
Thanks in advance for any advice!
Bookmarks