populate a list from a value in another list or combo box

[xlvirgin]

Hi All,

I'm new here (and to excel) so hope I have posted this in the right palce.

I have a worksheet in which Col. A contains the names of London boroughs and col. B contains the name of each Ward in that borough.

I'd like to create a list (or combo) box showing all the London boroughs, and a second list (or combo) box which will show all the Wards for the Borough selected in the London list (combo) box. I'd also like the option to be able to select all the Wards for the borough selected so that they can be used in a chart\graph.

I have no idea to do this.....and am hoping that someone o=here can at least point me in the right direction.

Thanks in advance

XLV

[Chance2]

My thoughts on this are as follows:

1) Create a unique list of the Boroughs.
Can be done by highlighting Col A and using Data-->Filter-->Advanced Filter

2) Create a drop down list for the unique Boroughs
Can be done using Data-->Validation-->List

3) Create a Named Range for the Wards
See the attached for the OFFSET/MATCH/COUNTIF formula

4) Create a drop down list for the Wards using the Named Range

Note: If you want to create these drop downs on a separte sheet, then you will need to create a Named Range for the unique Boroughs in step 2.

[xlvirgin]

Many thanks Chance2!!!

I'm still wrapping my head around what you've done\suggested (with Excel for Dummies at my side!) but really appreciate your help.

XLV

[Reiro]

Howzit Guys,

I know this is an old tread but hoping to get a response.

Where on the worksheet do i find the formula for the below step:

"See the attached for the OFFSET/MATCH/COUNTIF formula"

Thanks