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
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