If Graham doesn't mind, and I follow what you're doing and I'm not sure I do...
You only need to use the Worksheet_Change event of the sheet containing the 4 dates.
You will need to refer to the other sheets by their "code name" in order to always be working with the same sheet.
Your dates must be entered manually or with VBA. They cannot be the result of a formula.
|