techissue2008
Board Regular
- Joined
- Jun 13, 2008
- Messages
- 80
Hi
I have a sheet 1, it has 2 columns.
(A)
Football
Bastketball
Swimming
....
(B)
2004
2003
2003
......
In worksheet 2, I want to show 2 pull down menus
(1) Football
(Select * from A where B=2004)
(2)
Bastketball
Swimming
(Select * from A where B=2003)
In worksheet 3, I want to show 1 pull down menu but the result will be shown.
(1) '2003' pull down menu
(Select * from A where B=2003)
It shows:
Bastketball
Swimming
How can I do it?
Thanks for help
I have a sheet 1, it has 2 columns.
(A)
Football
Bastketball
Swimming
....
(B)
2004
2003
2003
......
In worksheet 2, I want to show 2 pull down menus
(1) Football
(Select * from A where B=2004)
(2)
Bastketball
Swimming
(Select * from A where B=2003)
In worksheet 3, I want to show 1 pull down menu but the result will be shown.
(1) '2003' pull down menu
(Select * from A where B=2003)
It shows:
Bastketball
Swimming
How can I do it?
Thanks for help