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.