| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation Problem
Figured it out now....
Cheers Mark "Mark S" wrote: Hi I am trying to create a drop down list for a cell using data validation. I need my data source to be on a different worksheet so I can easily edit it. How do I reference the data on a different worksheet in the data validation source field? I have set up a defined name for the list of cells I need to reference to make it simpler, however I get the error message that I cannot reference cells not on the same worksheet as the drop down list... The help file says however that this is possible .. Any help would be appreciated |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation problem | Excel Discussion (Misc queries) | |||
| Problem with Data Validation and limiting characters | Excel Worksheet Functions | |||
| Data validation problem | Excel Discussion (Misc queries) | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Linear Mode
