I have a value in B5 which fluctuates.
I have 2 columns--DATE and POSITION. I have a macro that records each DATE and its corresponding value under POSITION. The corresponding value is whatever appears in cell B5 for that date.
What I need is for that value under POSITION to also fluctuate just like in B5 but ONLY throughout THAT DATE. Once the day 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?
NOTE:
My own suggestion:
could it be like this?
If last row under DATE = Today, then
Last row in position = B5
Then, create a string of code which would copy the contents and paste only the cell VALUE both
- at 23.59
- before closing the document.
If what I wrote is wrong, please just ignore and go straight for the best answer.
thank you.
Bookmarks