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

sadonnie

New Member
Joined
Dec 17, 2018
Messages
11
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
1641920074289.png


ServerList Worksheet
1641920024686.png


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

New Member
Joined
Feb 13, 2022
Messages
2
Office Version
  1. 365
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?
 

Attachments

  • Souce Data.jpg
    Souce Data.jpg
    120.9 KB · Views: 5
  • DOUBLE CLICK SHEET.jpg
    DOUBLE CLICK SHEET.jpg
    212.8 KB · Views: 5

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,400
Messages
5,837,024
Members
430,467
Latest member
FrazzledbyExcel

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
Top