Hi all,
My primary worksheet (Sheet 2) contains a table that updates based on changes to the referent cells on Sheet 4.
I want to make VBA timestamp my table on Sheet 2 anytime the total changes, i.e. when the Sheet 4 referents make Sheet 2 change.
I am using the following code now:
The problem I'm having is that this timestamp macro only works if I *MANUALLY* edit the contents of the target cell (the 'total' cell from Sheet 2's table). So I get a timestamp if I manually change the target. But I want a timestamp automatically when the target cell is changed by changes in Sheet 4.
Any ideas guys? Thank you!
Bookmarks