| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop Down Menu ~ Source from Different Spreadsheet
Can't get the 2 spreadsheets to link. Created "defined name" with reference
to the source spreadsheet. Destination spreadsheet will not allow me to use the defined name in the validation list reference. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Drop Down Menu ~ Source from Different Spreadsheet
If "spreadsheet" means a separate workbook (file) then the source workbook
must be open. See your other post. -- Biff Microsoft Excel MVP "Diane" wrote in message ... Can't get the 2 spreadsheets to link. Created "defined name" with reference to the source spreadsheet. Destination spreadsheet will not allow me to use the defined name in the validation list reference. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Drop Down Menu ~ Source from Different Spreadsheet
Take a look at this site; I think this will do what you need it to do:
http://www.contextures.com/xlDataVal08.html#Refer Regards, Ryan--- -- RyGuy "Diane" wrote: Can't get the 2 spreadsheets to link. Created "defined name" with reference to the source spreadsheet. Destination spreadsheet will not allow me to use the defined name in the validation list reference. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| filter dropdown menu so 2nd drop menu is customized | Excel Worksheet Functions | |||
| Place source to drop down list in another spreadsheet | Links and Linking in Excel | |||
| drop-down menu in an excel spreadsheet | Excel Worksheet Functions | |||
| Cross-referenced drop-down menu (nested drop-downs?) | Excel Worksheet Functions | |||
| How do I set up a drop-down menu within an Excel Spreadsheet? | Setting up and Configuration of Excel | |||
Linear Mode
