| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to create a drop down menu which referencing a different workb
I followed the Microsoft Help instruction to create drop down list. It says
i can create a drop down list in separete worksheet or different workbook. but only the separate worksheet seems to work. I tried to link my drop down menu to different workbook and it shows this error message "You may not use reference to other worksheets or workbook for data validation criteria". what does it mean? how can i create a drop down menu and link it to a different workbook? Joanne |
|
#2
|
|||
|
|||
|
check out this web site
http://www.contextures.com/xlDataVal05.html -- paul remove nospam for email addy! "Joanne" wrote: I followed the Microsoft Help instruction to create drop down list. It says i can create a drop down list in separete worksheet or different workbook. but only the separate worksheet seems to work. I tried to link my drop down menu to different workbook and it shows this error message "You may not use reference to other worksheets or workbook for data validation criteria". what does it mean? how can i create a drop down menu and link it to a different workbook? Joanne |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ho Do I create drop down menu? | Excel Worksheet Functions | |||
| How do I create a Calendar Drop Down menu for a Validation cell | Excel Worksheet Functions | |||
| How do I set up a drop down menu within a drop down menu? | Excel Discussion (Misc queries) | |||
| how do I create a drop down menu in Excell? | Excel Worksheet Functions | |||
| how do i create drop down menu in excel | Excel Worksheet Functions | |||
Linear Mode
