Hi all,

I hope you can help - I know how to auto-update a field with today's date when saving a file, but I need to instead enter today's date only when the field next to it has been altered.

For example, cell A1 contains text and cell A2 is where I wish the date to show
If cell A1 text changes, is deleted etc then I'd like to have cell A2 to update from whatever date it was previously, to todays date.

Then the same for B1 and B2, C1 and C2 etc

I hope this makes sense, thank you in advance