Double-click in cell in one Excel sheet auto-filters another sheet based on multiple filter criteria

[sadonnie]

I have read through the other posts and some reference using the Hyperlink Event and some use the BeforeDoubleClick event. I am open, just stuck on how to best approach the VBA code.

Scenario:
I have 1 workbook with 2 worksheets:
1. Worksheet 1 name is Wave
2. Worksheet 2 name is ServerList

Screenshots of Worksheets:

Wave Worksheet

ServerList Worksheet

Objective:
As a user, I want to go to the WAVE worksheet and click on a # value in either column 7 or column 8 (Production or Non-Production) in order to auto-filter the ServerList Worksheet to display those specific servers.

Example: (clicking the #7 under the Production List column)
In the WAVE worksheet, when I click on the #7 under the Production list column (in row 2 under column 7) it will filter the Serverlist worksheet to show me those specific 7 servers. The criteria I need help coding is when I click on the # 7, I need to capture the APP ID value in Column 4 of the WAVE worksheet and the that I clicked the #7 in the PRODUCTION column. I need the word "Production". I don't care if Production/Non-Production is hard-coded since that will never change as a value.

So using the app id value (in column 4) and knowing I clicked on the value under the PRODUCTION column (column 7) I would have the code auto-filter the ServerList worksheet with the criteria AppID = 228 and Environment = Production. That would show me the specific 7 servers.

Conversely, If I clicked the #4 in Column 8 (row 3), it would auto-filter the ServerList worksheet with the criteria AppID = 229 and Environment = Non-Production. That would show me the specific 4 servers.

I have been stuck trying to use either DoubleClick vs Hyperlink and getting the correct values to pass to the auto-filter.

Any help is greatly appreciated from the community here!

Thanks

 

[Muthuv19]

Please help me with this i have 8 Columns to Filter from a dashboard with Rows ranges from D1 TO D7 each cell will filter different columns and Different criteria in source data, can you help me with it

I have attached images
Sheet 1: Source Data
Dashboard(Sheet): Double Click Sheet from D2:D7

When i Double click cells from D2 to D7 it should filter each category in Source data with the key word i mentioned in B Column in Dashboard Sheet
Can you help me with the VBA Code?