May 03 2022 08:46 AM
In a table of data, I'm trying to assign a column ("AJ") to record the date if any cell within the same row, "A" to "AI" may have been changed.
Data range = A6:AI1000
Date recording column = AJ
This would then be applied to AJ6:AJ1000 to record each line item's update history.
I'd like to be able to undo as well, I've seen some VBA codes wipe the memory once a code has run.
Any help much appreciated.