Can't see Validation

[JMB_0159]

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

 

[JoeMo]

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?

 

[JMB_0159]

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

You are correct, The list is defined on another worksheet.

 

[JoeMo]

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]

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]

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.