| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
data validation on other sheet
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 |
|
#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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
data validation on other sheet
If you give that list on the secondary sheet a nice name, you can use it in your
data|validation. See Debra Dalgleish's site: http://www.contextures.com/xlDataVal01.html#Name "Pierre via OfficeKB.com" wrote: 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 -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
data validation on other sheet
Thanks Tom, works great.
Pierre Tom Ogilvy wrote: 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 Hi, [quoted text clipped - 3 lines] Thanks, Pierre -- Message posted via http://www.officekb.com |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
data validation on other sheet
Hi Tom,
Is there also a way to do the following: ist 2 columns (for example 'client number' and 'name') in the validation field. When a client is chosen, only use the client number to fill the cell with. Thanks, Pierre Pierre wrote: Thanks Tom, works great. Pierre Insert = Name = Define [quoted text clipped - 16 lines] Thanks, Pierre -- Message posted via http://www.officekb.com |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
data validation on other sheet
Not with data validation. You can have an adjacent cell that does a vlookup
on the client name, or if it is on the right of the client number, you can use =index(ClientNumberRange,Match(validationCell,Clie ntNameRange,0),1) while waiting for a selection in the data validation cell =if(validationcell="","",index(ClientNumberRange,M atch(validationCell,Client NameRange,0),1)) -- Regards, Tom Ogilvy "Pierre via OfficeKB.com" <u13950@uwe wrote in message news:58bcdcf16033d@uwe... Hi Tom, Is there also a way to do the following: ist 2 columns (for example 'client number' and 'name') in the validation field. When a client is chosen, only use the client number to fill the cell with. Thanks, Pierre Pierre wrote: Thanks Tom, works great. Pierre Insert = Name = Define [quoted text clipped - 16 lines] Thanks, Pierre -- Message posted via http://www.officekb.com |
| Reply |
| 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) | |||
![Pierre via OfficeKB.com[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
