These are called Dependent Dropdown Lists. They are created using named
ranges and INDIRECT() formulas on the following lists.

Here's a link to a sample sheet I created to show someone else how they're
constructed. The drop box choices are sheet "Choices" and the sheet "Lists"
shows how they are laid out.

http://www.excelforum.com/attachment...ndentlists.xls

Take a look and see if that will help you.

You can read further about them here if that's not enough to get you going:
http://www.contextures.com/xlDataval02.html



--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"zac" wrote:

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