Active Member
July 9, 2016
Hello,
I have an Excel table that multiple users where multiple users will enter and change records. I would like to have a column that will populate with the current date when any data in that row is changed. Can someone provide the code for this. I found a code online that does this, but it applies to all rows on the worksheet. I would like it to only apply to table rows. Thank you!
VIP
Trusted Members
June 25, 2016
Active Member
July 9, 2016
Thanks for the reply and code, Sunny. This isn't what I'm looking for. I would like code that references only the table data, not the entire worksheet. For example, if the table is in B1:Q50 (headers in Row 1), with column Q header "Date Revised", I would like the code to only populate in Q2:Q50. If 3 table rows are added, the code would populate Q2:Q53.
VIP
Trusted Members
June 25, 2016
VIP
Trusted Members
June 25, 2016
VIP
Trusted Members
June 25, 2016
VIP
Trusted Members
June 25, 2016
Hi David
The macro uses a worksheet change event (no need to run the macro).
Any changes to a cell's value within the Table will trigger the macro automatically.
The macro will then display today's date in column Q (same row as the cell that was changed) to indicate that the cell was changed (revised) on that date.
Sunny
1 Guest(s)