I have a value in A1 which fluctuates.
I have 2 columns--DATE and REGISTRY. I have a macro that records each DATE and its corresponding value under REGISTRY. The corresponding value is whatever appears in cell A1 for that date.
What I need is for that value under REGISTRY to also fluctuate just like in A1 but ONLY throughout THAT DATE. Once the date is over (or the document is closed), I need it to freeze the value (whatever value it showed last).
Can anyone help me with this?
I have 2 columns--DATE and REGISTRY. I have a macro that records each DATE and its corresponding value under REGISTRY. The corresponding value is whatever appears in cell A1 for that date.
What I need is for that value under REGISTRY to also fluctuate just like in A1 but ONLY throughout THAT DATE. Once the date is over (or the document is closed), I need it to freeze the value (whatever value it showed last).
Can anyone help me with this?