P
PZ
Worksheet has changeable data clients input in columns W to AP.
Looking for macro to time date stamp in column V in the same row each
time the data is changed anywhere in columns W to AP. Some inputs are
freeform text and numbers, some are from dropdown list.
Most of the postings show how to have one column update the next
column over such as http://www.mcgimpsey.com/excel/
timestamp1.html#alt1
the only way i could get it to work for any changes for all columns
was to run the test for each column which starts to take time.
Seems like there should be an easier way to post the data to column V
for each row that regardless of which column generated the change
event. Possilbe to change McGimpsey's code to accomplish this task?
Looking for macro to time date stamp in column V in the same row each
time the data is changed anywhere in columns W to AP. Some inputs are
freeform text and numbers, some are from dropdown list.
Most of the postings show how to have one column update the next
column over such as http://www.mcgimpsey.com/excel/
timestamp1.html#alt1
the only way i could get it to work for any changes for all columns
was to run the test for each column which starts to take time.
Seems like there should be an easier way to post the data to column V
for each row that regardless of which column generated the change
event. Possilbe to change McGimpsey's code to accomplish this task?