I have a worksheet that has a dynamic cell (A1) with a constantly changing value. I want to record a history of this value and the time and date that it has changed. I have found some VBA solutions online that can do a time/date stamp or a list history of the value but not a VBA solution that does both. So ideally I would have:
A1 - Dynamic value
B1 - First historic value of A1, C1 - Date/time stamp
B2 - Second historic value of A1, C2 - date/time stamp
and so on.
Once I have this list I would then wish to be able to lookup the list so that I could get the historic value of A1 at the end of each month and record this so that it can feed in to a performance dashboard. I did have an array formula solution that was initially working but this formula was made using indirect and then became volatile.
I hope someone can help. Thank you.
Bookmarks