Drop down reference

[Gee...]

I used to know how to do this but have drawn a blank:

There is a way to name a range on another sheet and have
it be like a drop down arrow in a cell on a different
sheet...then you can reference other cells in the 2nd
sheet based on the drop down.
I can't remember how you do it.

 

[John Michl]

The range in the other sheet must be named. When adding data validation to
the cell, select List and then enter "=NameOfRange" without the quotes. You
must include the equals sign. According to Microsoft, you are not supposed
to be able to use a list from another sheet so I guess you'd call this a
helpful bug!

John Michl
www.JohnMichl.com

 

[RagDyer]

Debra Dalgleish has a number of web pages dedicated to this subject.

Start at this one:
http://www.contextures.com/xlDataVal01.html
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I used to know how to do this but have drawn a blank:

There is a way to name a range on another sheet and have
it be like a drop down arrow in a cell on a different
sheet...then you can reference other cells in the 2nd
sheet based on the drop down.
I can't remember how you do it.

 

[Juan Sanchez]

Its in DATA > Validation > Allow > List...

Select your source, or type the name and your set...


Cheers
Juan