techissue2008
Board Regular
- Joined
- Jun 13, 2008
- Messages
- 80
Hi
I have a worksheet 1, it has 5 columns.
(A)
Team A
Team B
Team C
Team D
.....
(B)
Team E
Team F
Team G
Team H
.....
(C)
87:90
78:88
90:92
85:89
.....
(D)
2005
2005
2005
2006
.....
(E)
Round 1
Round 1
Round 1
Round 2
It means Team A vs Team E, score result 87:90 in year 2005.
In worksheet 2, I want to show 2 cell pull down menus in (A) row
(1) Team in (A)
(2) Year in (D)
When I choose All Team and 2005, it will show the result in (A3) row
(A3) Empty (B3) Round 1 (B3) Round 2
(A4) Team A (B4) Team E (87:90)
(A5) Team B (B5) Team F (78:88)
(A6) Team C (B6) Team G (90:92)
(A7) Team E (B7) Team A (87:90)
(A8) Team F (B8) Team B (78:88)
(A9) Team G (B9) Team C (90:92)
How can I code it?
Thanks for help
I have a worksheet 1, it has 5 columns.
(A)
Team A
Team B
Team C
Team D
.....
(B)
Team E
Team F
Team G
Team H
.....
(C)
87:90
78:88
90:92
85:89
.....
(D)
2005
2005
2005
2006
.....
(E)
Round 1
Round 1
Round 1
Round 2
It means Team A vs Team E, score result 87:90 in year 2005.
In worksheet 2, I want to show 2 cell pull down menus in (A) row
(1) Team in (A)
(2) Year in (D)
When I choose All Team and 2005, it will show the result in (A3) row
(A3) Empty (B3) Round 1 (B3) Round 2
(A4) Team A (B4) Team E (87:90)
(A5) Team B (B5) Team F (78:88)
(A6) Team C (B6) Team G (90:92)
(A7) Team E (B7) Team A (87:90)
(A8) Team F (B8) Team B (78:88)
(A9) Team G (B9) Team C (90:92)
How can I code it?
Thanks for help