VB code update a cell with date when data changed

DonnaHall

New Member
Joined
Apr 8, 2010
Messages
1
Hi

I am looking for code to update the date cell for each entry if any data is changed within the spreadsheet

eg I have a sheet with details of work on it. Each row is a new item of work with an 'Updated' entry at the end of each row. I need the date for each individual workstream to update to todays date if the details within the row have been amended.

I have seen code to update a particular cell (ie $A$10) but I need this to be relative to the row amended.

thanks
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Watch MrExcel Video

Forum statistics

Threads
1,108,482
Messages
5,523,207
Members
409,504
Latest member
Joshcurrie

This Week's Hot Topics

Top