Excel2003, dynamic lists with multiple select?

[LolaM]

Hey folks, OK I have a really (I think) complicated one here...

I need to be able to create dynamic lists to 3 layers... so using the data below...

Col A |Col B |Col C
Company |Department |Person
ACME |Finance |Louis
ACME |Sales |Bob
ACME |Sales |Mark
BigCo Co |Finance |Bob

I want to be able to:

1. Select a Company (Col A) from a list shown in cell E1
2. Select a Department (Col B) that occurs in the selected Company in cell F1
3. Select a Person (Col C) from the selected Department in cell G1

So, if I select 'ACME' in E1, the list in cell F1 shows ONLY Finance or Sales (and Sales shows only once ideally), and if I select 'Sales' in F1, the list in G1 shows ONLY Bob or Mark.

The lists are dynamic, in that they may change based on data copied/pasted from another location to Cols A, B & C.

Any help would be gratefully received!! I am stumped on this one...

 

[vavs]

Try this link:

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

I think it will explain how to do everything you want to do and then some.