E.g. in my sheet, if I double click on A, B, or C I want it to filter the pivot table to that one.
E.g. in my sheet, if I double click on A, B, or C I want it to filter the pivot table to that one.
Place the code given below on Sheet1 Module and to do that follow the steps given below...
1. Right click on Sheet1 Tab Name and choose View Code.
2. Copy the code and paste it into the opened code window.
3. Save your file as Macro Enabled Workbook.
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks