I am fairly inexperienced using Excel, and am seeking some assistance finding the right code for a date stamp issue.
I would like to be able to have the current date inserted into a specific column when any of the cells between column A to I in that row are changed.
I would like the cell in column J to have the current date inserted when the any cells in columns A to I are changed within the same row. At the moment I have managed to have a date stamp inserted into the relevant row of column J when I enter/modify contents of cells in column A, using the following code:
If anyone knows what code I should be using to have the date stamp in the same column but enable this to happen when ANY cell in the same row between column A and I are modified, that would be fantastic.
Bookmarks