| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
data validation on other sheet
Insert = Name = Define
Name: List1 RefersTo: =Sheet3!$A$1:$A$20 Click the Add Button then in data validation under source put in =List1 -- Regards, Tom Ogilvy "Pierre via OfficeKB.com" <u13950@uwe wrote in message news:58bc677c6ce89@uwe... Hi, If i use datavalidation and use a list to choose from, i can only make a list on the same sheet where the cells are with data validation. how can i have a list to choose from that is on another sheet ? Thanks, Pierre -- Message posted via http://www.officekb.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation in another sheet | Excel Discussion (Misc queries) | |||
| Data Validation List from different sheet | Excel Discussion (Misc queries) | |||
| data validation works in one sheet but not another | New Users to Excel | |||
| Data Validation fromanother sheet | Excel Discussion (Misc queries) | |||
| Data Validation doesn't work on 1 sheet only | Excel Discussion (Misc queries) | |||
Threaded Mode
