Can a macro erase it's self after a set criteria?
I have a spread sheet that I use that has a macro that extracts data from a DB.
This is great for a snap shot but I want to capture this data over time.
Is it possible to set a formula/macro in a cell that would do 1 of three
things
1) tomorrow €“ do nothing, maintain the formula in the cell
2) today €“ copy data from a different location or run a formula
3) Yesterday €“ force the data captured yesterday to stay in the cell as a
value.
I hope that makes sense.
--
Jeff
|