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!
Hi PaulaS
Refer my attachment.
It uses a worksheet change event to find the row that was changed and add today's date to column 1 of that row.
Hope this helps.
Sunny Kow
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.
Hi PaulaS
See if this is what you are looking for.
From your reply above, I am not sure if you want to populate the entire column Q (Date Revised) with today's date or only for that particular row.
I populated the entire column Q (Date Revised) in my attachment.
Sunny Kow
Hi PaulaS
This attachment can update either entire column or specific row in column Q (Date Revised).
Just modify the codes.
Sunny Kow
That's it! The code only adds the date if the row is in the table. Thank you very much.
Hi PaulaS
Glad that helps
Sunny Kow
A bit lost and sorry , pls show how to run this VB..
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
Oh I see thanks Sunny !
