Excel template Help

[zac]

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

 

[JBeaucaire]

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/attachmen...-populate-cells-with-lists-dependentlists.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