Quote Originally Posted by Dreamboat
Did you notice that all his data validation lists were repeated on any sheet on which he used it? (He didn't use named ranges)
There has been a thread here suggesting that no more than one Excel name should be used!