excel - 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!
解决方案
推荐阅读
- sql-server - 如何将权限从一个数据库复制到另一个数据库?
- ios - 如何从中央设备(iPhone 7)将布尔值写入外围设备(PSoC BLE)
- reactjs - 反应生命周期方法
- r - 在列名中搜索字符串并检索每一行的相应值
- python - QWidget::setLayout: 试图在已经有布局的 ProgramWindow "" 上设置 QLayout ""
- ajax - f:ajax 不会渲染 h:panelGroup
- java - Cucumber/Gherkin - 在“背景”中放置“时间”术语是否可以接受?
- android - 如何从硬编码数据更改为数据库数据?
- php - Yii2如何将接收到的JSON数据保存到数据库中
- matlab - 为什么这个函数会产生“Inf”的值?