Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Named Range From One Workbook Used in Validation Drop Down in 2nd Workbook
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Named Range From One Workbook Used in Validation Drop Down in 2nd Workbook
Hey Biff,
That works for me, thanks. -Minitman On Tue, 19 Aug 2008 01:49:49 -0400, "T. Valko" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Named Range From One Workbook Used in Validation Drop Down in 2nd Workbook
You're welcome!
-- Biff Microsoft Excel MVP "Minitman" wrote in message ... Hey Biff, That works for me, thanks. -Minitman On Tue, 19 Aug 2008 01:49:49 -0400, "T. Valko" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying named lists used in drop downs from one workbook to anothe | Excel Worksheet Functions | |||
Data validation drop downs don't recognize dynamic named range | Excel Discussion (Misc queries) | |||
Named Range in ANOTHER workbook | Excel Discussion (Misc queries) | |||
Named Range in ANOTHER workbook | Excel Discussion (Misc queries) | |||
Named Range in another workbook | Excel Worksheet Functions |