How to pre select validation

[JBW]

I have 13 categories and each of them has approx ten subcategories.
When you select the category in column A from a drop down validation list I
want only that categories subcategories to be available from the column b
drop down list.

how?

 

[MartinW]

Hi JBW,

Take a look at Debra Dalglesih's site
http://www.contextures.com/xlDataVal13.html

HTH
Martin