Excel Drop Down Lists
 

Is it possible to create a drop down list in a cell that looks at a range of
values on a different sheet?

Mike

Excel Drop Down Lists
 

Yes, you can reference a DV list on another sheet. You'll need to create a
Range Name for the list. You miight even want to create a Dynamic Range Name.

See Debra Dalgleish's website for instructions.

Start he
http://www.contextures.com/xlDataVal01.html

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Michael Kintner" wrote:

Is it possible to create a drop down list in a cell that looks at a range of
values on a different sheet?

Mike

Excel Drop Down Lists
 

Worked GREAT!!! Thanks....


"Ron Coderre" wrote in message
...
Yes, you can reference a DV list on another sheet. You'll need to create
a
Range Name for the list. You miight even want to create a Dynamic Range
Name.

See Debra Dalgleish's website for instructions.

Start he
http://www.contextures.com/xlDataVal01.html

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Michael Kintner" wrote:

Is it possible to create a drop down list in a cell that looks at a range
of
values on a different sheet?

Mike