Try what's suggested here and see if it helps.

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

HTH,
Barb Reinhardt

"Dando265" wrote:

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