Cell Pull down menu with 'where' condition

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
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
How can I relocate the column (E) to be a row (1)?

I searched it for 2 days. No result. Even the logic of it cannot be found.

I posted it here, no result.

I posted it to other forums, but being banned as cross posting.

How can I know all of excel forums are managed by the same group of people? Why not just market one excel forum but have several excel forums. Really not understand.
 
Upvote 0

Forum statistics

Threads
1,213,527
Messages
6,114,144
Members
448,552
Latest member
WORKINGWITHNOLEADER

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top