How do I link 2 data sets to 2 drop down menus?
 

I created 2 drop down menus, but I want to link the data to these menus and I
don't know how. I can send my spreadsheet to someone if they can look at it
and tell me how I can get the data to change when I change my selection in
the drop down menu.

How do I link 2 data sets to 2 drop down menus?
 

If you want dropdown lists in a cell, you can use data validation. There
are instructions in Excel's help, and he

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

dralden wrote:
I created 2 drop down menus, but I want to link the data to these menus and I
don't know how. I can send my spreadsheet to someone if they can look at it
and tell me how I can get the data to change when I change my selection in
the drop down menu.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

How do I link 2 data sets to 2 drop down menus?
 

No need to send anything.

Describe your ranges.............where are the drop-downs and where is your data
stored and where do you want the changes to take place?

e.g. dropdown in A1.......data table in F1:H25

Data to be returned to C1

Are you using Data Validation Drop-downs?


Gord Dibben MS Excel MVP

On Thu, 10 May 2007 08:54:00 -0700, dralden
wrote:

I created 2 drop down menus, but I want to link the data to these menus and I
don't know how. I can send my spreadsheet to someone if they can look at it
and tell me how I can get the data to change when I change my selection in
the drop down menu.