Multiple Dependent Lists based on Selection in 1st Column

[TinkerBleu]

Hello Everyone,

I have been using the forum a lot the past few days and have been able to find help on all but one (at the momemt) item for my spreadsheet. I'm not sure if this is possible but...

What I am looking to do is this... (using Excel 2007)

I need to have more dependent lists based on the selection in Column A. (My column B is already set up and works perfectly using INDIRECT)

For example:
Column F would be a dependent list of colors based on the sales rep chosen in Column A
Column I would be a dependent list of managers based on the sales rep chosen in Column A
Column M would be a dependent list of part numbers based on the rep chosen in column A

Is it possible to do this - without using VBA? (If I HAD to - okay, the other person maintaining the sheet would be lost....) I haven't been able to find anything close to what I want to do online - maybe I am just not using the correct terms.

Thank you very much!!!
(my apologies if I placed this in the wrong forum...)

[jeffreybrown]

Hello & Welcome to the Board,

Could something here help you http://www.contextures.com/xlDataVal02.html

If not could you post a sample workbook of what you have and what you expect?

[TinkerBleu]

Hi Jeffrey,

The document you suggested has been very helpful . If my answer is in there - maybe I am not understanding how to apply the formula to what I am trying to do.

Here is the sample spreadsheet - I have all the lists and info in the Lists sheet for you. I haven't named the ranges beyond the first set - simply because I wasn't sure how to.

On The Reps sheet, I have my Region Drop Down in A, and based on the Region - I choose from the Dependent List of Sales Reps names in Column B. (works perfectly..)

Column C& D are data entry columns

Column E - I want to choose a color based on the Region chosen in Column A.

Colums F&G are data entry columns

Column H - I want to choose a Product based on the Region chosen in Column A.

Is it doable?

Thanks!

Daun

[TinkerBleu]

Thank you for your help. I was able to find the solution!

I found it on another website - not sure if I should post the link for the solution.

Thanks!

Daun

[jvermillion]

Can you please post the solution I have been having the same trouble you have.

[JEM1]

Hi TinkerBleu,

It will be great if you can direct me as well to the website you found which helped you solve this problem (Refer your reply below).
I am trying to create the same thing you did.

Your assistance is greatly appreciated.

Thank you.


JEM

Re: Multiple Dependent Lists based on Selection in 1st Column
Thank you for your help. I was able to find the solution!

I found it on another website - not sure if I should post the link for the solution.

Thanks!

Daun