Hi all,
I am having an issue that I cannot solve for the life of me, heck I dont even know if its possible.
Basically as part of my job, managers are supposed to complete a daily log of information for their staff, and this is all accumulated on one work book. Ie/ 1st, 2nd, 3rd ect, each page has the same information that is required to be inputted ie/ mileage, start time, comments ect.
We're having a lot of issues with managers inputting and moving formulas, which is messing the entire process up.
Is there any way, on this work book, I can lock each day, and just have one summary page at the end, where for example there is a drop-down menu of all the drivers names, then another drop down of the date I wish to input data for, then a box below where they can input data, then this data is automatically transferred onto the selected day in the workbook, and then can click that day to see all of the inputted data?
I'd EXTREMELY appreciate it if anyone could help, or offer advice?
Thank you very much
Bookmarks