Hello all.
I have a number of cells with pop up boxes with for instance dates to select.
These are linked via data validation to some dynamic ranges on another sheet.
If I change the date from say 1st march to 1st april in the dynamic range, the cells which currently have 1st March in stay that way.
Is there a way for that cell to realise I swapped out March for April and change accordingly?
Bookmarks