Hi all,
looked thru the forum, but can't seem to find an answer to my issue. I am looking for a way (can be a formula or macro) to take a snapshot of a specific cell (let's say B3) every Friday on a particular time & store it in an array - (column O), so I can later on see what the B3 value was in previous weeks. Attaching screenshot for reference, hope it's clear. The value in B3 will always be a simple value - a singular letter - G or A or R.
Capture.JPG
Would appreciate all the help :-)
Bookmarks