Excel Drop Down Lists

  • Thread starter Thread starter Michael Kintner
  • Start date Start date
M

Michael Kintner

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

Mike
 
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 here:
http://www.contextures.com/xlDataVal01.html

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

XL2002, WinXP
 
Worked GREAT!!! Thanks....


Ron Coderre said:
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 here:
http://www.contextures.com/xlDataVal01.html

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

XL2002, WinXP
Click to expand...
 
You must log in or register to reply here.

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 List problem 5
Data Validation List (conditional) 2
Clear a "moving" range offset from Target 31
How to dynamically change the list in drop down list based on thevalue of another cell? 1
Define the Range of a drop-down list 5
EXCEL DROP DOWN 2
Pick from drop-down list gives empty or erroneous result 6
Link Drop Down list with Pivot Table 3

Back
Top