Dynamic Drop Down List?

[JoeJaycee]

Here is what I'm needing to accomplish:

1. In sheet "Colors" I have a list of colors in column A.

2, In sheet "Teams" I want to assign a unique color in column B to each team listed in column A.

3. I want to create a drop down list in each cell of column B to select a color from the list of colors.

4. Then once a particular color is selected in a cell, it should not show as a choice to pick from iwhen you move to the next cells.


Any help would be appreciated!! Thanks!

[Winon]

Hello JoeJaycee,

Without using Name Manager, you need to copy the list of Colors to the Sheet for "Teams".

See WorkBook attached. You may also hide the two columns containing the actual colors.

Also see the "Please consider:" notes at the bottom of this Post

[Winon]

Hello JoeJaycee,

Since you have started a new Thread, you may now have the courtesy of marking this one as Solved.

Thank you.

Glad to see you came right with my Formula and use it via the Name Manager. Good going!

[JBeaucaire]

See the post/file I've given in your other thread here:
http://www.excelforum.com/excel-prog...10#post2736010

This is a little more dynamic and eliminates the spaces in your drop down lists.

You should mark this thread as resolved...

[marreco]

See too Jerry Beaucaire's Excel Files & Macros

Here is some really cool inside.

I learned and enjoyed a lot, make a visit!

[JoeJaycee]

I do not know how to mark this thread as solved!?!

[marreco]

Go to your 1st post -> Edit -> Advanced, change the dropdown arrow to SOLVED