View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Don Don is offline
external usenet poster
 
Posts: 487
Default Data Validation - can you use another workbook?

morning friends

Is there a way to use the Data/Validation List to use a named range in
another workbook? I want to maintain the list in one place yet have mult
workbooks utilize this so when I have to update the list of dropdowns , I can
do it in one place.

thanks