validation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi
how am i to apply validate to a particular column
based on the values from diffrent worksheet?
thanks
 
You must name the range in the other sheet and then when you refer to the
range in validation you would enter:
=NameRange

Hope this helps from a beautiful day in South Africa
 
thanks Les G
should i use =worksheetname!namedrange?
thanks and enjoy a beautiful day in South Africa
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide column based on data validation 0
Data Validation List (conditional) 2
A data validation question 1
Excel VBA 1
range naming and conditional creation 4
Disable paste option in worksheet. 1
How do I create Dynamic Dropdowns 1
seperate field criteria to diffrent worsheets or files 2

Back
Top