Look at Data=PivotTable report.

--
Regards,
Tom Ogilvy


"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