Create List base on cell

[shah_ir85]

[TABLE="class: grid, width: 1000"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[TD]H
[/TD]
[TD]I
[/TD]
[TD]J
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Home Team
[/TD]
[TD]Home Score
[/TD]
[TD]Away Score
[/TD]
[TD]Away Team
[/TD]
[TD]Scorer 1
[/TD]
[TD]Scorer 2
[/TD]
[TD][/TD]
[TD]Team A
[/TD]
[TD]Team B
[/TD]
[TD]Team C
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Team A
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Team B
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Player A1
[/TD]
[TD]Player B1
[/TD]
[TD]Player C1
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]Team C
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Team D
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Player A2
[/TD]
[TD]Player B2
[/TD]
[TD]Player C2
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Player A3
[/TD]
[TD]Player B3
[/TD]
[TD]Player C3
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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.