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!

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

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

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