Named Range From One Workbook Used in Validation Drop Down in 2nd Workbook

[Minitman]

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

 

[T. Valko]

See this:

http://contextures.com/xlDataVal05.html

 

[Minitman]

Hey Biff,

That works for me, thanks.

-Minitman

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

Hey Biff,

That works for me, thanks.

-Minitman