| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dropdown box HELP
Is there any way for me to create a drop down box from a list of data in a
different work from the one the drop down box will be in??? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Dropdown box HELP
If you use defined/named ranges, you can.
Apply it in the DV with Allow: List, Source: =MyRange where MyRange is a defined range -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "DP7" wrote: Is there any way for me to create a drop down box from a list of data in a different work from the one the drop down box will be in??? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Dropdown box HELP
Hi, I think I am applying your suggestion wrong. I name the range of cells in
one workbook. I then try to insert the range in the reference box of the list options in the other woorbook and it still gives me the same error. Could u please provide a little more detail that could help me along my way. Thanks once again. "Max" wrote: If you use defined/named ranges, you can. Apply it in the DV with Allow: List, Source: =MyRange where MyRange is a defined range -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "DP7" wrote: Is there any way for me to create a drop down box from a list of data in a different work from the one the drop down box will be in??? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Dropdown box HELP
The former assumed you meant from other worksheets
For workbooks, try Debra's page at: http://www.contextures.com/xlDataVal05.html Excel -- Data Validation -- Use a List from Another Workbook -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "DP7" wrote: Hi, I think I am applying your suggestion wrong. I name the range of cells in one workbook. I then try to insert the range in the reference box of the list options in the other woorbook and it still gives me the same error. Could u please provide a little more detail that could help me along my way. Thanks once again. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| result of selecting from the dropdown list should be a dropdown list | Excel Worksheet Functions | |||
| result of selecting from the dropdown list should be a dropdown list | Excel Worksheet Functions | |||
| Zero is a dropdown Take 2 | Charts and Charting in Excel | |||
| offer dropdown options based on another dropdown | Excel Discussion (Misc queries) | |||
| How do I create a dropdown within a dropdown? | Excel Discussion (Misc queries) | |||
Linear Mode
