| 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 | |||
Linear Mode
