Data Validation Dependent List

[Tomaljoe69]

	A	B	C	D	E	F	G	H	I
1	Regions	Club
2
3
4
5
6
7
	Sheet 1

<tbody>
</tbody>

	A	B	C	D	E	F	G	H	I
1	Region	Army BA	East Midlands	Eastern Counties	Home Counties	London	Merseyside & Cheshire	Midlands	North West Region
2	Army BA	Army BA	Aldercar & Langley Mill ABC	Berry	Aylesbury ABC	Alma ABC	1st Class ABC	Aston ABC	ABC Bolton Champions
3	East Midlands		Allenton Boxing Academy ABC	Billericay WICKFORD	Bedford ABC	Barking Boys ABC	Aintree ABC	Birmingham City ABC	Ambleside ABC
4	Eastern Counties		Bolsover ABC	Braintree	Bishop Stortford ABC	Broad Street ABC	Anfield ABC	Bromford ABC	Ancoats Lads ABC
5	Home Counties		Buxton ABC	Brentwood Youth	Bletchley ABC	CITY OF LONDON POLICE ABC	BIRCHGREEN ABC	DnA Boxing School ABC	Ardwick Lads ABC
6	London		Chadd ABC	Canvey	Bushey ABC	County ABC	Birkenhead Venture	Eastside ABC	Ashton Albion
7	Merseyside & Cheshire		Chesterfield ABC	Castle	Cheshunt ABC	Dagenham (Police & Community) Boxing Club	Bootle ABC	Hall Green ABC	Astley V.I.P ABC
8	Midlands		Derby City Boxing Academy ABC	Centurion	Dallow ABC	EAST LONDON BOXING ACADEMY	Boxing Fit Academy	Kingstanding Second City ABC	Barrow ABC
9	North West Region		Dronfield ABC	Chadwell St Mary	Heath & Reach ABC	Fairbairn ABC	Chester Police ABC	Nechells Green ABC	Barton ABC
	Sheet 1

<tbody>
</tbody>

Hello

These are my two sheets of data, in sheet one in cell A2, I have set up a Data Validation list to select from source in Sheet 2 Cell range A2:A9. I would like the list in column two to be dependent on the selection on Column1, so for example if i select East Midlands the Options in the adjacent Cell in column 2 will be limited to the range in Sheet 2 C2:C9, I cant seem to get it from the info people have provided so far, so detail instructions would help thanks again

John

 

[jorismoerings]

Hi John,

You have the lists already generated, that's brings you already halfway to the solution. Take a look here : Excel Dependent Drop-down Lists - Easy Excel Tutorial

Is this what looking for?

If so; here's a link to a testmodel : https://app.box.com/s/kbmkkom53vjid9vfrvv8dy5j8gdviknk

 

[Tomaljoe69]

Hello

Thanks for your help but this is not quite what I am looking for;

The Header for Column A sheet 1 is "Regions" and the header for Column B is Club.

I will input data from Cell A2 dowands, I have 8 selections to choose from.
The Data list for this cell is Found in sheet 2 in the range A2:A9 I have 8 choices,
Dependent on this on my choice in Sheet 1 cell A2, choice of region I would then like the list in B2 to be restricted to the choices within that region.
For example if I select Army BA in Cell A2 then in cell B2 I will be restricted to the list of "clubs" in the range B2 found on Sheet 2
For example if I select East Midlands in Cell A2 then in cell B2 I will be restricted to the list of "clubs" in the range C2:C9 found on Sheet 2
For example if I select Eastern Counties in Cell A2 then in cell B2 I will be restricted to the list of "clubs" in the range D2:D9 found on Sheet 2

I do not want to use any more the two columns on Sheet 1

Hope that makes Sense

Thanks again for your help

	A	B
1	Regions	Club
2
3
4
5
6
7
	Sheet 1

<tbody>
</tbody>

A	B	C	D	E	F	G	H	I
1	Region	Army BA	East Midlands	Eastern Counties	Home Counties	London	Merseyside & Cheshire	Midlands	North West Region
2	Army BA	Army BA	Aldercar & Langley Mill ABC	Berry	Aylesbury ABC	Alma ABC	1st Class ABC	Aston ABC	ABC Bolton Champions
3	East Midlands		Allenton Boxing Academy ABC	Billericay WICKFORD	Bedford ABC	Barking Boys ABC	Aintree ABC	Birmingham City ABC	Ambleside ABC
4	Eastern Counties		Bolsover ABC	Braintree	Bishop Stortford ABC	Broad Street ABC	Anfield ABC	Bromford ABC	Ancoats Lads ABC
5	Home Counties		Buxton ABC	Brentwood Youth	Bletchley ABC	CITY OF LONDON POLICE ABC	BIRCHGREEN ABC	DnA Boxing School ABC	Ardwick Lads ABC
6	London		Chadd ABC	Canvey	Bushey ABC	County ABC	Birkenhead Venture	Eastside ABC	Ashton Albion
7	Merseyside & Cheshire		Chesterfield ABC	Castle	Cheshunt ABC	Dagenham (Police & Community) Boxing Club	Bootle ABC	Hall Green ABC	Astley V.I.P ABC
8	Midlands		Derby City Boxing Academy ABC	Centurion	Dallow ABC	EAST LONDON BOXING ACADEMY	Boxing Fit Academy	Kingstanding Second City ABC	Barrow ABC
9	North West Region		Dronfield ABC	Chadwell St Mary	Heath & Reach ABC	Fairbairn ABC	Chester Police ABC	Nechells Green ABC	Barton ABC
	Sheet 2

<tbody>
</tbody>

 

[jorismoerings]

Hi,

That was exactly as the explanation and the testmodel did.
To make it clear i've converted the testmodel towards your needs:
https://app.box.com/s/qom7ojgx0fsskg33ukldtt3lcusjc06t