Create 3 dependant lists from one list

  • Thread starter Thread starter Dando265
  • Start date Start date
D

Dando265

Hi,
I'm stuck trying to create three dependant lists from a selction of
another list.

My Products are shutters made from different materials,(1st list)
Craftwood, Lockwood, and Basswood.

Each of these products have different louvre options (1st dependant on
list1)
They also have diffent frame options (2nd list dependant on list1)
And finally they have different colours (3rd list dependant on list1)

Can anyone help me please, i'm really struggling with this.

Thanks

Dando265
 
Look at Data=>PivotTable report.

--
Regards,
Tom Ogilvy








- Show quoted text -
Click to expand...

I,ve had a look at the pivot table and I don't think it's going to
work for me. The speadsheet I'm working on is an order sheet and there
is just enough room to disply the full sheet on my tablet pc. I'm not
sure what I'm doing with the pivot table but apeared to take up more
space than 1 cell like a drop down list.
 
It is adaptable, tough not necessarily easy.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Since I'm not seeing my web interface posts from today displayed anywhere,
I'm guessing there's a technical problem, so I'll repost using OE:

--------------------------

I'll use only 2 manufacturers to save space...

With

Range Named: Mfg_List in F1:F3
(contains the mfg list: Craftwood, Lockwood, and Basswood

Range Named: Craftwood_Louvre in G1:G10
(contains the Options)

Range Named: Craftwood_Frame in H1:H10
(contains the Options)

Range Named: Craftwood_Color in I1:I10
(contains the Options)

Range Named: Lockwood_Louvre in J1:J10
(contains the Options)

Range Named: Lockwood_Frame in K1:K10
(contains the Options)

Range Named: Lockwood_Color in L1:L10
(contains the Options)


Then....create these list-based DV cells:
Note: as you create each DV
....Excel will warn you that it currently evaluates to an error
....ignore the warning

A1: (contains DV List, based on Mfg_List)
B1: (contains DV List, based on =INDIRECT(A1&"_Louvre")
C1: (contains DV List, based on =INDIRECT(A1&"_Frame")
D1: (contains DV List, based on =INDIRECT(A1&"_Color")

Does that help?

Regards,

Ron
Microsoft MVP (Excel)
 
Dando265 said:
Hi,
I'm stuck trying to create three dependant lists from a selction of
another list.

My Products are shutters made from different materials,(1st list)
Craftwood, Lockwood, and Basswood.

Each of these products have different louvre options (1st dependant on
list1)
They also have diffent frame options (2nd list dependant on list1)
And finally they have different colours (3rd list dependant on list1)

Can anyone help me please, i'm really struggling with this.

Thanks

Dando265
Click to expand...
 
Dando265 said:
Hi,
I'm stuck trying to create three dependant lists from a selction of
another list.

My Products are shutters made from different materials,(1st list)
Craftwood, Lockwood, and Basswood.

Each of these products have different louvre options (1st dependant on
list1)
They also have diffent frame options (2nd list dependant on list1)
And finally they have different colours (3rd list dependant on list1)

Can anyone help me please, i'm really struggling with this.

Thanks

Dando265

Hello,
Click to expand...

I think you would do best with a "Case" statement:
Private Sub Image_Change()
Select Case Me.Image.Value

Case "IPSD Base"
With Me.Project
.Clear
.AddItem ""
.AddItem "N/A"
End With
Case "CPSE Base"
With Me.Project
.Clear
.AddItem ""
.AddItem "N/A"
End With
Case "CPSE Development"
With Me.Project
.Clear
.List = Array(" ", "AMA", "ATHN", "Feller", "Future", "Phoenix",
"Janus", "K700", "KMS", "MEGA", "PSD", "SEBR")
End With
End Select
End Sub

Note that this something I made for 2 dropdown lists. If the user chooses
"CPSE" in the first list, the 2d list displays the choices "AMA", "ATHN",
"Feller", "Future", "Phoenix", "Janus", "K700", "KMS", "MEGA
 
Back
Top