Hi,

I have got an excel template. In column "A" I have provided with a
drop down with categories 1, 2, 3.....28. Against each category I have
got sub categories1.1,1.2,1.3/ 2.1, 2.2, 2.3..... My requirement is if
I am selecting a category using the dropdown, the corresponding
subcategory should be shown as a drpdown in column "B".

Thanks in advance
Shaiju