| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop-down List range define
Hi
i need some help to define a range of cells that belong into a different book and a different sheet... I named an area AA into a AA.xls...and i want to make this area my source into BB.xls for my drop down list... Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
drop-down List range define
Define a name in bb.xls mylist that refers to aa.xls!aa. Then list =mylist -- Don Guillett SalesAid Software "vassilis" wrote in message ... Hi i need some help to define a range of cells that belong into a different book and a different sheet... I named an area AA into a AA.xls...and i want to make this area my source into BB.xls for my drop down list... Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
drop-down List range define
See Debra Dalgleish's site for instructions.
http://www.contextures.on.ca/xlDataVal05.html Note that source workbook must be open. Gord Dibben MS Excel MVP On Sun, 17 Dec 2006 07:40:01 -0800, vassilis wrote: Hi i need some help to define a range of cells that belong into a different book and a different sheet... I named an area AA into a AA.xls...and i want to make this area my source into BB.xls for my drop down list... Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
drop-down List range define
yes but what do i need to write to point at the external defined area ?
i ve tried of c:\aa.xls.aa and doesnt work .... "Don Guillett" wrote: Define a name in bb.xls mylist that refers to aa.xls!aa. Then list =mylist -- Don Guillett SalesAid Software "vassilis" wrote in message ... Hi i need some help to define a range of cells that belong into a different book and a different sheet... I named an area AA into a AA.xls...and i want to make this area my source into BB.xls for my drop down list... Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Use of List box (drop down) | Excel Discussion (Misc queries) | |||
| Conditional Drop Down List | Excel Discussion (Misc queries) | |||
| Define a range containing the first 10 rows of a filtered list | Excel Worksheet Functions | |||
| input range in drop down list | Excel Discussion (Misc queries) | |||
| changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions | |||
Linear Mode
