Hey, trying to figure out how to count/tally the amount of times a cell is changed.
Specifically, when someone puts in today's date, it should tally 1. Then tomorrow when they update the date it would tally 2.
Hey, trying to figure out how to count/tally the amount of times a cell is changed.
Specifically, when someone puts in today's date, it should tally 1. Then tomorrow when they update the date it would tally 2.
This will require VBA. I will move the thread.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Put this code in the worksheet object that you're counting changes for:
See attached for an example. Hope that helps. MM.Please Login or Register to view this content.
MatrixMan.
--------------------------------------
If this - or any - reply helps you, remember to say thanks by clicking on *Add Reputation.
If your issue is now resolved, remember to mark as solved - click Thread Tools at top right of thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks