data validation

[ahhhmed]

Why can't I make data validation (drop-down list) referring to other worksheets?

 

[fred]

I don't know why either. But you can use combox box instead.

 

[Luke M]

Sneaky ninja method:

Several Excel features "claim" that you can't reference another worksheet (advanced filter, data validation, etc). However, if your first setup a named range, it'll work just fine. So, define "MyRange" as:

='Sheet2'!$A$2:$A$10


Then, in your data validation, list is:

=MyRange


Voila! Excel has no problem. =)

http://www.contextures.com/xldataval05.html

 

[fred]

Cool! thanks!

 

[OleMiss2010]

You can also type it in manually to refer to another sheet. So in the data validation field you can type:

='Sheet2'!$A$2:$A$10

This is a less preferable way of doing it in my opinion, but it is an option.

 

[ahhhmed]

Thanks all