how to link different dropdown lists

--------------------------------------------------------------------------------

Hopefully this will make sense,

I have a work book that contains various sheets with different information.
I have two different categories in one of the sheets,1 which contains counties and the other containing districts.I have done a validation for the county which allows me to pick a county from a drop down list which works fine.I would like to create a drop down list for the districts aswell such that when i select i.e southyorkshire from the counties dropdown list,the districts drop down list will bring only districts in southyorkshire,excluding all the other districsts.hopefully i'll like the same to apply to all other counties.

Please can I get some help on this.

Here is a spreadsheet that may help you.

Originally Posted by fodeps

--------------------------------------------------------------------------------

Hopefully this will make sense,

I have a work book that contains various sheets with different information.
I have two different categories in one of the sheets,1 which contains counties and the other containing districts.I have done a validation for the county which allows me to pick a county from a drop down list which works fine.I would like to create a drop down list for the districts aswell such that when i select i.e southyorkshire from the counties dropdown list,the districts drop down list will bring only districts in southyorkshire,excluding all the other districsts.hopefully i'll like the same to apply to all other counties.

Please can I get some help on this.

Check here for a tuturial

Dependant Lists

You need to create named ranges for each of those columns... (and make that your permanent table).

Then the data validation has to be separate (e.g. in another area, sheet)...

See attached...

Go to Insert|Name|Define to see how each was named

Cell H2 is where you select a team

Then I2 is the dependant list that shows up based on the selection made in H2.

Hi,

I thought I'd improve on it a bit for you and allow for dynamic ranges...

so that it doesn't show blanks in your drop down lists and also allows for you to add items to any of the columns and this will update the drop downs automatically....

See attached.. note the changes in the named ranges and in the formula for data validition in I2.

Hope this helps more.