Hi JBW,

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

HTH
Martin


"JBW" wrote in message
...
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?