| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down list from a different worksheet
I want to have a drop down on a worksheet populate from another worksheet in
the same workbook. The Help instructions tell me that it can be down but when I follow the instructions I get a message telling me it can't be done. Very confusing. Does anyone know which is right? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Drop Down list from a different worksheet
It can be done, as long as you name the range that contains the list or
items. There are instructions he http://www.contextures.com/xlDataVal01.html Boo wrote: I want to have a drop down on a worksheet populate from another worksheet in the same workbook. The Help instructions tell me that it can be down but when I follow the instructions I get a message telling me it can't be done. Very confusing. Does anyone know which is right? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Drop Down list from a different worksheet
Watch this 5 minute video:
http://youtube.com/watch?v=t2OsWJijrOM -- Biff Microsoft Excel MVP "Boo" wrote in message ... I want to have a drop down on a worksheet populate from another worksheet in the same workbook. The Help instructions tell me that it can be down but when I follow the instructions I get a message telling me it can't be done. Very confusing. Does anyone know which is right? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a worksheet using a drop down list? | Excel Worksheet Functions | |||
| add data t drop down list use a different worksheet same workbook | Excel Worksheet Functions | |||
| Populating worksheet via a drop down list ! | Excel Worksheet Functions | |||
| drop-down list validation won't allow a different worksheet | Excel Worksheet Functions | |||
| Sorting a worksheet with drop list | Excel Discussion (Misc queries) | |||
Hybrid Mode
