Date/Time Stamp

**TLC1981** · 07-21-2016, 02:13 PM

I have a workbook that has 6 sheets. Each sheet has data that is updated periodically in columns L:R. I need a date/time stamp that shows the latest update in the row. I created a formula that would update when a change took place, however it changed all date/time stamps on all rows with data. I need only the row that has been changed to be updated. I have seen some VBA suggestions on that forum but I can't get that working either. I may need to note that this file will be shared among multiple users. Any help would be appreciated, I'm using Office 365 proplus (2016). I have attached a sample of this file.

**6StringJazzer** · 07-21-2016, 02:19 PM

Requires a macro. Here is your file with a macro implemented. This macro will update the date/time no matter what changes on the line. If the user changes the date/time itself, no update will be made. This allows the user to delete a line if necessary, leaving the date/time blank.

**TLC1981** · 07-21-2016, 07:56 PM

Awesome, Thanks!

**6StringJazzer** · 07-21-2016, 09:03 PM

I just noticed that you only wanted to check columns L:R. I didn't limit to those columns. I can revise, if you'd like. Let me know.

Date/Time Stamp

LinkBack

Thread Tools

Rate This Thread

Display

Date/Time Stamp

Re: Date/Time Stamp

Re: Date/Time Stamp

Re: Date/Time Stamp

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Convert Unix Date-time stamp to excel date and/or time columns

Need vba code to change date&time stamp as date format dd-mmm-yy in A:A rng

Adding time (more than 24 hours) to date time stamp

[SOLVED] Splitting a time stamp into one column for time and another for date

Need to capture date data in a text string containing a date and time stamp

[SOLVED] Extract a time from a cell with date and time stamp and then perform calculations

Time and date stamp

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions