Selecting the best option depends how your source lists are set up.
There are a few variations on dynamic validation lists he

http://www.contextures.com/excelfiles.html

Maybe one of those would be better in your workbook.

Angeles wrote:
Hi , I have a question for you ..... I need to have dynamic Validation Lists
and I have implemented a solution that I found in this forum , using the
option in excel Insert - Name - Define I have defined my lists of values ,
but they are 85 posible lists , do you think that is the best option for
implementing this ? I refer to the managment memory and enhancement.

Thank you in adavance.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html