Create macro upon double click cell display filter in new sheet

Hello,

I have a question regarding creating macros whereas the scenarios as follows:

Sheet1
Upon clicking any cell in Sheet1, it will automatically filter based on cell A and B.

Sheet2
Automaticall display filtered criteria based on double click from Sheet1

For example: when I double click on C1, on Sheet2 will automatically diplay filtered data based on A1 and B1 and same thing goes to if I double clik on C2 on Sheet2 will automatically diplay filtered data based on A1 and B2.

Really need help from the experts here.

Thank you.filter.png

Hi Dave,

Thanks for the replied which I do really appreciate it. I can see from the example that it integrated the button inside the sheet. From my requirement, instead of using the button and combo box to copy and paste the data, my data already existed in Master Sheet (sheet2) and from sheet1I would be able to double click the correspond cell and auto filter all the data in master sheet (sheet2).

For example, I double click the cell C1, it will auto read cell A1 and B1 (same goes to the rest of the rows) and auto filter in Master sheet which correspond to the selection in Sheet1.

Sound easy but I couldn't figure out the exact VBA code.

Thank you

project.xlsx

Sorry for the file, it should be for example B2 & A2 and same goes for others. Whereas it will automatically open sheet Master with filter up only all A1 and P1 and etc.... So sorry for the wrong info


Copy of project.xlsx

Atatched herewith the latest which accomplished.

Book1f.xlsm