Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Excel 2003
Hello, I am trying to create a drop-down list in a workbook based on a range of cells in another workbook via the Data, Validation menu commands. I have followed the steps as specified in the Help system which state that I can reference a "different worksheet in a different workbook." However when I try to create the list I receive the message that you cannot use external references (I am using a named range created in the workbook that references the external cells). Thanks for any help you can provide. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help needed - creating invoice from packing list (both in excel) | Excel Discussion (Misc queries) | |||
Help needed - creating invoice from packing list (both in excel) | Excel Discussion (Misc queries) | |||
Creating a List based on your choice from Another List | Excel Discussion (Misc queries) | |||
question about creating a simple drop down list | Excel Worksheet Functions | |||
Creating an invoice with a lookup list | Excel Discussion (Misc queries) |