First off, I'm really not experienced at all, just downloaded a free template from a website and just edited it and added a few simple formulas to suit my needs.
So, I've got a timesheet that supposedly tracks the start time, end time, project name and all those things, mind you, not a weekly timesheet, but a daily timesheet. I also have a row above all those columns showing the date and I resorted to a simple drop down list with each day and month. Now, the problem is, instead of copying the same table over and over again in a sheet, I want instead, whenever I change the date from the drop down list, all the cells that include the start time, end time, project name etc. to "reset" and likewise whenever I go back to a date that I've previously added data, to appear.
Is there any way in which I can do this ?
https://we.tl/t-TQBWbUTmqh - worksheet file
So, I've got a timesheet that supposedly tracks the start time, end time, project name and all those things, mind you, not a weekly timesheet, but a daily timesheet. I also have a row above all those columns showing the date and I resorted to a simple drop down list with each day and month. Now, the problem is, instead of copying the same table over and over again in a sheet, I want instead, whenever I change the date from the drop down list, all the cells that include the start time, end time, project name etc. to "reset" and likewise whenever I go back to a date that I've previously added data, to appear.
Is there any way in which I can do this ?
https://we.tl/t-TQBWbUTmqh - worksheet file