I've created an Excel workshop to allow people track the different work activities they engage in over the working day (it's for a study we are doing). The idea is that everyone in my department will have a copy of the worksheet open on their computer at their desk and will record in realtime the different work activities they do over the day. I'm trying to make it as foolproof as possible by locking down everything except the cells they ned to complete.
My problem is that I want Excel to create new worksheet everyday that is labelled with the current date. However, I want this worksheet to be the template I created (e.g. column headings, formulas, etc) rather than a completely blank worksheet. I also want Excel to either do this automatically when the workbook is opened each day or else have a button on the workbook that the person clicks to do it.
I'm relatively new to Excel so have just been learning as I go along. I also don't have any knowledge of Visual Basic.
I've attached a copy of the workbook (the password for both the sheet and the workbook is thescientist
Any tips or help with this would be much appreciated.
Bookmarks