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...![Eek! :eek: :eek:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
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...