I need to be able to count how many times a cell has been altered and record the dates it has been altered. This must be recorded every time the cell is altered.
The cell I need to monitor will contain the date.
And the count of how many times it is altered and all the dates it has been altered need to be on a separate, hidden worksheet within the workbook.
Would anybody have any ideas on how to help with this?
Thanks in advance.
A sample workbook uploaded showing your current data and then indicating where you wish to place your results and what fields/cells you wish to track. The more information the easier to resolve.
Hi, quite some time ago I fund this code snippet.
I save what I find as text files
The link where I found it is in the attached file and all you need to do is read it and edit it to your needs
Hopes this helps
And yes, if you want specific help then attach a file as Alan Sidman says