Create List base on cell

[shah_ir85]

	A	B	C	D	E	F	G	H	I	J
1	Home Team	Home Score	Away Score	Away Team	Scorer 1	Scorer 2		Team A	Team B	Team C
2	Team A			Team B				Player A1	Player B1	Player C1
3	Team C			Team D				Player A2	Player B2	Player C2
4								Player A3	Player B3	Player C3
5

<tbody>
</tbody>

Hye mate...i have question about drop list base on cell.

I just want you to help me how to make auto list at E2...E3...F2...F3 base on Team at D2...D3....and the list is at H2-H4

If i change D2 from Team B to Team C...then at E2 or F2 the list also will change to J2-J4...

please help me if you understand

Best Regard

 

[Scott T]

If I understand correctly you want to do dependent data validation. This Video shows how to do dependent data validation.

Excel Magic Trick 774: Dynamic Data Validation AND Dependent Data Validation Together - YouTube

 

[shah_ir85]

tQSM mate. Really appreciate it

 

[Scott T]

Glad to help.