Forum Discussion
Record every change in a range of cells in a column to sheet2 with the time and date of change.
Hi, I need help. I need to record the changes in a range of cells in a single column to a new sheet with the time of the change and next change on a new cell. record changes on Sheet1, Column A, C...
But the value in B5 on the new sheet could refer to another time than the value in B6, B7 etc.
Can you tell us what the new sheet should actually look like?
I have shared an attachment for example. Hope it helps..
In the new sheet, the details for the cells on sheets1 should be saved horizontally. as on the old sheet, all data are stored in a column.
If time cannot be placed commonly for all changes, then maybe an option if changes after every min could be recorded.
The attached example will record the values of column A on Sheet1 every minute, whether a change has occurred or not.
It is a macro-enabled workbook, so you have to allow macros for it to work.
There is code in a standard module and in the ThisWorkbook module.