首页 > 解决方案 > Excel: Resetting table based on day

问题描述

I'm gonna start by saying that I am not that experienced in excel and whatnot but I can manage with some instructions although I ran into a bit of a problem. 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 like I said, I'm not that experienced, I resorted to a 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 added data previously, to appear.

Is there any way in which I can do this ? Thank you!

标签: excel

解决方案


推荐阅读