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