No Phideaus, your Excel program isn't coming undone.... that's Excel 2003.
Things improved with the newer versions, but that doesn't help you right now.
Tables weren't introduced until Excel 2007.
Excel 2003 can't apply validation from another sheet unless you use named ranges.
Manually giving each range a name and formulating when to use it... not for me.
In the attached, the Schedules is moved to a separate sheet which can be hidden.
The macro in Module1 only needed to be run once to name the ranges.
The WorkSheet_Change event monitors the cells of 'Front Sheet' column A for changes and uses the same calculation
as the NameRanges macro to determine 'on the fly' what range to use for validation in the adjacent column B cell.
Don't know if this is of any use to you or not but at least have a look.
|