| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clearing a cell value after a set time period - Macro??
I didn't find an answer to this when quickly looking over past discussions.
What I want to do is clear a cell value out after eight hours or so. I may have a production line that ran yesterday but that is not running today. I have production tabs in an Excell 2003 spreadsheet with a summary tab that everything is totalled into. If the line doesn't run today their past data is still in their tab. I would like the ability to automatically clear out their production data so it doesn't get totalled in my summary page after the date changes or after a set time period. That way when I am totalling up a days worth of production I'm not counting a line that may not be running today. I hope this makes sense. Thansk! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Clearing a cell value after a set time period - Macro??
Just some questions...
How would you know if the data is today's data or yesterday's? Couldn't you use that same criteria to determine whether it should be included or not? If you're using some formula to return the value for today's date, maybe you could modify that formula to look at the date for that entry (assuming each entry gets a date)???? Boiler-Todd wrote: I didn't find an answer to this when quickly looking over past discussions. What I want to do is clear a cell value out after eight hours or so. I may have a production line that ran yesterday but that is not running today. I have production tabs in an Excell 2003 spreadsheet with a summary tab that everything is totalled into. If the line doesn't run today their past data is still in their tab. I would like the ability to automatically clear out their production data so it doesn't get totalled in my summary page after the date changes or after a set time period. That way when I am totalling up a days worth of production I'm not counting a line that may not be running today. I hope this makes sense. Thansk! -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Clearing a cell value after a set time period - Macro??
If the line is not running today, then I the spreadsheet data on this tab is
from a previous day. I am not looking at any date. The other tabs may have valid data if that particular line is running today. So when I total everything in my TOTAL tab, if I don't get the non-running line to clear out its info then I have inflated production numbers. Todd. "Dave Peterson" wrote: Just some questions... How would you know if the data is today's data or yesterday's? Couldn't you use that same criteria to determine whether it should be included or not? If you're using some formula to return the value for today's date, maybe you could modify that formula to look at the date for that entry (assuming each entry gets a date)???? Boiler-Todd wrote: I didn't find an answer to this when quickly looking over past discussions. What I want to do is clear a cell value out after eight hours or so. I may have a production line that ran yesterday but that is not running today. I have production tabs in an Excell 2003 spreadsheet with a summary tab that everything is totalled into. If the line doesn't run today their past data is still in their tab. I would like the ability to automatically clear out their production data so it doesn't get totalled in my summary page after the date changes or after a set time period. That way when I am totalling up a days worth of production I'm not counting a line that may not be running today. I hope this makes sense. Thansk! -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Clearing a cell value after a set time period - Macro??
I understand how you (a human) would know.
I don't understand how a computer/program/macro would know. Boiler-Todd wrote: If the line is not running today, then I the spreadsheet data on this tab is from a previous day. I am not looking at any date. The other tabs may have valid data if that particular line is running today. So when I total everything in my TOTAL tab, if I don't get the non-running line to clear out its info then I have inflated production numbers. Todd. "Dave Peterson" wrote: Just some questions... How would you know if the data is today's data or yesterday's? Couldn't you use that same criteria to determine whether it should be included or not? If you're using some formula to return the value for today's date, maybe you could modify that formula to look at the date for that entry (assuming each entry gets a date)???? Boiler-Todd wrote: I didn't find an answer to this when quickly looking over past discussions. What I want to do is clear a cell value out after eight hours or so. I may have a production line that ran yesterday but that is not running today. I have production tabs in an Excell 2003 spreadsheet with a summary tab that everything is totalled into. If the line doesn't run today their past data is still in their tab. I would like the ability to automatically clear out their production data so it doesn't get totalled in my summary page after the date changes or after a set time period. That way when I am totalling up a days worth of production I'm not counting a line that may not be running today. I hope this makes sense. Thansk! -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro for clearing cells | Excel Discussion (Misc queries) | |||
| Macro for clearing cell contents | Excel Discussion (Misc queries) | |||
| Clearing All check boxes using Macro | Excel Discussion (Misc queries) | |||
| average rate of change per given time period between 2 moments in time of a value | Excel Worksheet Functions | |||
| Every time i put a number with period it becomes a date and time | Excel Discussion (Misc queries) | |||
Hybrid Mode
