Jan 31 2022 10:20 AM - edited Jan 31 2022 10:25 AM
I have a set list of items and need to have a column that shows when the last time the cell next to it was modified. In the attached example column A will always be the same, column B will be modified periodically . I need column C to show the date of last modification of each items in column B. I know this can be achieved with VBA but have not really worked with VBA much. Column A will mostly likely have ~5k items in it
Jan 31 2022 10:33 AM
SolutionMaybe as shown in the attached file.