Data Validation

D

Dave Eade

I want to base my data validation on a list on another worksheet within the
same workbook - excel doesn't seem to want me to do this?
Is there any way round referencing the cells on the other worksheet?
 
L

Luke M

you could create a group of cells on your current sheet that reference the
other sheet (a simple ='Sheet2'!A2 type formula), and hide them (maybe
IV2:IV100?)
and then have your data validation base its list off of that.
 
L

Luke M

Found a solution!

Select the lsit of cells in your second sheet, and name this range. (Upper
left where cell address is normally displayed, type a name, e.g. MyRange, and
confirm with Enter).

Now, for your data validation, select list, and then input
=MyRange
 
T

Tanya M

It seems to me I've gotten around that by naming my list and using that range
name. Be sure to enter the range name with an equal sign... i.e. =Range
 

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 3
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
2007 data validation not working 1
Excel 2003 Data Validation 2
Data validation on data validation function 1
copying data validation to another workbook 3
data - validation - list question 2
Creating A List of Items Between Two Numbers 2

Top