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