Is it possible to make combined drop down menues?

**jimme1982** · 02-17-2009, 12:22 PM

Hey.

I have an excel sheet with a drop down menu with more than 50 options.

What I want to ask is if it possible to tie two drop down menues to eachother and make them dependable on eachother.

Lets say I have two coulmns A and B. In coulmn I have numbers and in coulmn I have different work tasks tied to each number.

F.ex.
Col A | Col B
-------------------
1 . . . | walk
2 . . . | crawl
3 . . . | jump
4 . . . | run
...
7 . . . | swim
etc.
etc.

What I want is:
If I chose the number 4 in coulmn A I want it to select "run" in coulmn B.
If I chose 7 in A I want it to write "swim" in B.
Here is the kicker though. I want to be able to choose "run" in coulmn B, and have it plug in 4 in coulmn A. In the same way choosing "swim" in B should make it choose 7 in A all by itself. So on and so forth for all the different number-task combinations.

If I only wanted it to work "one way" I could just use lookup, but that is not a possibilty here.

So is it possible to do what I want?

thx in advance,
jimme

**NBVC** · 02-17-2009, 12:24 PM

It is possible... have a look here.

Dependent Lists

**jimme1982** · 02-17-2009, 03:15 PM

Just tell me if i'm wrong and I need to look a little more carefully, but I don't think this solves my problem.

I the guide in the URL I first have to choose something in the first coulmn, and then based on what I chose there I can choose from a new drop down list in the 2nd coulmn.

That is not quite what I am looking for.

**NBVC** · 02-17-2009, 03:38 PM

You're probably going to need a VBA expert to hop in and assist....

**ChemistB** · 02-17-2009, 03:40 PM

What you're asking to do (two way dependancy) requires VBA but it is possible. Can you load up an example file? Using this type of VBA program does have it's drawbacks though (e.g. you won't be able to undo).

**jimme1982** · 02-17-2009, 06:17 PM

Originally Posted by ChemistB

What you're asking to do (two way dependancy) requires VBA but it is possible. Can you load up an example file? Using this type of VBA program does have it's drawbacks though (e.g. you won't be able to undo).

Undo has to be possible, so that won't work. I will just keep it the way it is now. Just wanted to see if it could get a little better.

Thx. for the effort though.

**John_Sorenson** · 04-03-2009, 01:15 PM

Did you figure this out. What I am trying to do is the opposite of what you want. I want to choose "walk" but then be able to use that cell to do a calculation with number 1.

**NBVC** · 04-03-2009, 01:17 PM

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.