Hi, I need a bit of help please.
I have a table that tracks learner progress. I would like to be able to show in a cell the last date any cell in a range was modified.
I have set this up as a table to allow others to add learners and not have to copy and past all of the formulas each time, so each time a new row is added the date has to relate to the cells in that row.
I would like to look at cells P4 to X4 and have the latest date that any of those cells were modified in Y4. When a new learner is added i would need Y5 to record the date from P5 to X5 and so on as new rows are added.
An alternative might be to take the date from O4 as this is calculated from cells P4 to X4 and should update whenever on of those cells changes.
I have looked at other VBA codes and they apply to the whole sheet or workbook and I would like to look at specific cells.
Any help would be greatly appreciated.
Many thanks
Keith
I have a table that tracks learner progress. I would like to be able to show in a cell the last date any cell in a range was modified.
I have set this up as a table to allow others to add learners and not have to copy and past all of the formulas each time, so each time a new row is added the date has to relate to the cells in that row.
I would like to look at cells P4 to X4 and have the latest date that any of those cells were modified in Y4. When a new learner is added i would need Y5 to record the date from P5 to X5 and so on as new rows are added.
An alternative might be to take the date from O4 as this is calculated from cells P4 to X4 and should update whenever on of those cells changes.
I have looked at other VBA codes and they apply to the whole sheet or workbook and I would like to look at specific cells.
Any help would be greatly appreciated.
Many thanks
Keith