Home |
Search |
Today's Posts |
#3
![]() |
|||
|
|||
![]()
TQ. I got it.
-----Original Message----- If you name the list on the other sheet, you can refer to it by name in the data validation dialog box. There are instructions he http://www.contextures.com/xlDataVal01.html wrote: Hello, I have try out couple of times to setup a validation in excel spreadsheet from different spreadsheets and I can't allow me to proceed. I can setup the validation in same spreadsheet but not in different spreadsheet. Appreciate your advise. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data Validation | Excel Discussion (Misc queries) | |||
Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Data Validation Window? | Excel Discussion (Misc queries) | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) |