Register
Log In
Unanswered
Home
July 9, 2016
Offline
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!
See Answer
Dashboards
June 25, 2016
Offline
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
July 9, 2016
Offline
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.Â
Dashboards
June 25, 2016
Offline
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
Dashboards
June 25, 2016
Offline
Hi PaulaS
This attachment can update either entire column or specific row in column Q (Date Revised).
Just modify the codes.
Sunny Kow
Answers Post
July 9, 2016
Offline
That's it! The code only adds the date if the row is in the table. Thank you very much.
Dashboards
June 25, 2016
Offline
Hi PaulaS
Glad that helps
Sunny Kow
December 5, 2016
Offline
A bit lost and sorry , pls show how to run this VB..
Dashboards
June 25, 2016
Offline
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
Most Users Ever Online: 57
Currently Online: Ali Bokhari
1 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Ali raza
Susan Booze
Rita Hrez
David Innes
preeti bhulabhai
Charles Klasek
Patrick Isedu
Emma Hayward
Vamseedhar G
NA NA
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
