|I have a column positioned at AL that records remarks relevant to each row of data. I need to record the date the each of the AL cells were last changed (date to be shown in Column AM). The remarks are updated by 6 different users regularly. There are up to 400 rows of data, but the users would only update a few rows at a time. If the user name can also be captured that would be a bonus.|
Therefore, if a user updated remarks in cells AL3, AL37 and A345 the date they carried out the change would appear in AM3, AM37 and AM345.
I have tried a couple of VBA examples from the forum but haven't found one that I was able to modify to fit my needs. Appreciate any help on this.