Forum

Count number of tim...
 
Notifications
Clear all

Count number of times a cell has changed and display dates every time

3 Posts
3 Users
0 Reactions
77 Views
(@cy_02)
Posts: 1
New Member
Topic starter
 

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.

 
Posted : 20/05/2023 9:14 am
Alan Sidman
(@alansidman)
Posts: 223
Member Moderator
 

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.

 
Posted : 20/05/2023 11:13 am
(@keebellah)
Posts: 373
Reputable Member
 

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

 
Posted : 21/05/2023 2:07 am
Share: