HI,

Assuming you have named your lists "dog", "cat" and "horse" then in B1
select "list" from the data validation menu and type: =INDIRECT(A1)

HTH
Jean-Guy



"Leisl" wrote:

Hi
Please bear with me, I know what I want I just can't explain it!

I have created a drop down list in cell A1 of dog, cat or horse. If A1
selects "dog" then I want cell B1 to create a further drop down list of
spaniel, doberman, retriever BUT if I select "cat" in cell A1 then I want
cell B1 to create a drop down list of siamese, berman or moggy and NOT
spaniel, doberman, retriever. Equally if I select "horse" in A1 then I want
the drop down list in cell B1 to say racehorse, showjumper or pony and NOT
spaniel, doberman, moggy etc.

I have already created a list of dog, cat, horse in the spreadsheet and also
lists for spaniel, doberman, retriever and then siamese, berman etc...
Any advice gratefully received. Thank you in advance.
Regards.
Leisl