| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down List from different sheet
Is it possible to have a drop down list using a list from a seperate
spreadsheet thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Drop Down List from different sheet
Found combo box on the forms toolbar, but this has a border around it and the
arrow also the text is a different size when printed !!!! "gibbylinks" wrote: Is it possible to have a drop down list using a list from a seperate spreadsheet thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Drop Down List from different sheet
"gibbylinks" wrote:
Is it possible to have a drop down list using a list from a seperate spreadsheet Yes, it's possible if you name the list range (either via the namebox or via clicking Insert Name Define) See Debra Dalgleish's nice coverage at her: http://www.contextures.com/xlDataVal01.html Scroll down a bit to the part: 2. Name the List Range "If you type the items on a worksheet, and name the range, you can refer to the list from any worksheet in the same workbook ..." -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Drop Down List from different sheet
Thanks Max
Sorted "Max" wrote: "gibbylinks" wrote: Is it possible to have a drop down list using a list from a seperate spreadsheet Yes, it's possible if you name the list range (either via the namebox or via clicking Insert Name Define) See Debra Dalgleish's nice coverage at her: http://www.contextures.com/xlDataVal01.html Scroll down a bit to the part: 2. Name the List Range "If you type the items on a worksheet, and name the range, you can refer to the list from any worksheet in the same workbook ..." -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Drop Down List from different sheet
"gibbylinks" wrote:
Thanks Max Sorted Great to hear that ! -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum up columns in different sheet with error check | Excel Discussion (Misc queries) | |||
| Displaying data from seperate sheet upon drop down box entry | Excel Worksheet Functions | |||
| Lookup function and compare | Excel Discussion (Misc queries) | |||
| time sheet drop down lists | Excel Discussion (Misc queries) | |||
| Conditional Drop Down List | Excel Discussion (Misc queries) | |||
Hybrid Mode
