[err] Excel 2007 - Data validation from another sheet?

J

Jon

I tried using the Data Validation in order to have the 'user' select from a
range of values. The list is in a hidden sheet within the worksheet.

However, the problem is that when selecting the Source, it does not allow me
to browse to another sheet.

In order to work around this I do a bit of "copy and paste" to get the
values of the reference sheet before copying to the 'Data Validation',
however it is a bit cumbersome :)
 
S

Sheeloo

You need to define a NAME for the range and use that in the validation...
Navigation INSERT->Name->Define
Enter the name in the topbox and range in the bottom and click ADD
 

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

data validation 1
Data Validation in another sheet 1
2007 data validation not working 1
data validation rule 4
copying data validation to another workbook 3
Protect Data validation cells from copy paste 3
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
VLookup using lookup table 1

Top