I have a workbook that is used in our team for our time recording. Everyone has their own workbook, and they can keep track of clocking in and out.
Each sheet references the previous sheet to keep a running total of the flexi-time that person has. The sheet has others thigs in it, such as a message when the time for lunch entered is less than 00:30:00.
What I am hoping to do is to find a way to add another sheet to each work book easily. At the moment I have to copy the sheet, delete any times already entered and then change all of the dates.
I am completely new to VBA, but can't think of a way to do this without using it. If anyone can help then ta very much.
Bookmarks