View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Named Range From One Workbook Used in Validation Drop Down in 2nd Workbook

See this:

http://contextures.com/xlDataVal05.html

--
Biff
Microsoft Excel MVP


"Minitman" wrote in message
...
Greeting,

I have 2 workbooks. The first has a dynamic named range which I need
to use in the second workbook as the source for a validation list.

Anyone have any ideas as to how this can be done?

Any help would be appreciated.

-Minitman