Can't see Validation

JMB_0159

New Member
Joined
Jul 7, 2009
Messages
24
Hi all, I have Validation on 2 columns within my work sheet, I cannot see the values within the list when you go to enter a value. If you input a wrong value it just comes up with a warning. I have a list defined on another page which is being referanced. The other thing is that if i add another worksheet and add validation to any columns or cells it works, can anyone help in determaining why it will not work in my original worksheet.

Much Appreciated
James
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

JoeMo

MrExcel MVP
Joined
May 26, 2009
Messages
16,835
Office Version
2010
Platform
Windows
Hi all, I have Validation on 2 columns within my work sheet, I cannot see the values within the list when you go to enter a value. If you input a wrong value it just comes up with a warning. I have a list defined on another page which is being referanced. The other thing is that if i add another worksheet and add validation to any columns or cells it works, can anyone help in determaining why it will not work in my original worksheet.

Much Appreciated
James
Is the "list defined on another page (I assume this is another sheet)" a named range?
 

JoeMo

MrExcel MVP
Joined
May 26, 2009
Messages
16,835
Office Version
2010
Platform
Windows
You are correct, The list is defined on another worksheet.
Then when you enter the reference in the data validation dialog box you must either refer to a named range or include the sheet name. For example, suppose the list is in cells A1:A5 on worksheet 'Sheet2' and you name it myList. Then you can use it as the list for data validation on another sheet (say Sheet1) if in the data validation refers to box you enter = myList. Alternatively, you can enter =Sheet2!A1:A5.
 

JMB_0159

New Member
Joined
Jul 7, 2009
Messages
24
Then when you enter the reference in the data validation dialog box you must either refer to a named range or include the sheet name. For example, suppose the list is in cells A1:A5 on worksheet 'Sheet2' and you name it myList. Then you can use it as the list for data validation on another sheet (say Sheet1) if in the data validation refers to box you enter = myList. Alternatively, you can enter =Sheet2!A1:A5.
Thats correct, In the Validation I have selected List and the list name Prime_Owner. this list consists of about a dozen names etc. I cannot see any values when i go to enter the value on the master sheet.
Would it be poss to send a copy of the file so that you can actually see what is / is not going on.

James.
 

JoeMo

MrExcel MVP
Joined
May 26, 2009
Messages
16,835
Office Version
2010
Platform
Windows
Thats correct, In the Validation I have selected List and the list name Prime_Owner. this list consists of about a dozen names etc. I cannot see any values when i go to enter the value on the master sheet.
Would it be poss to send a copy of the file so that you can actually see what is / is not going on.

James.
Send me a private message on this board and I'll send you an email address to send your file to.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,157
Messages
5,466,991
Members
406,513
Latest member
t0ny84

This Week's Hot Topics

Top