S seanteo New Member Jul 23, 2015 #1 Hi guys, I would like to know if anyone can help me to build a VBA to enable me for selecting an option from the combo box/drop down list (sheet1) and then the pivot table (sheet2) and normal data table (sheet3) will be filtered accordingly ? Thanks.
Hi guys, I would like to know if anyone can help me to build a VBA to enable me for selecting an option from the combo box/drop down list (sheet1) and then the pivot table (sheet2) and normal data table (sheet3) will be filtered accordingly ? Thanks.
S seanteo New Member Jul 23, 2015 #3 Hi Nebu, attached is the working file that I wish to have. Please see if this can be done ? Whenever user select an option in sheet1, then filter will be apply in sheet 4 (cell B1) and sheet 3 (cell A2) Attachments Reporting.xlsx 21.2 KB · Views: 1
Hi Nebu, attached is the working file that I wish to have. Please see if this can be done ? Whenever user select an option in sheet1, then filter will be apply in sheet 4 (cell B1) and sheet 3 (cell A2)
N Nebu Excel Ninja Jul 24, 2015 #4 Hi: Please find the attached. Change the combo box in sheet 1 , it will change both pivot and table filter . Thanks Attachments Reporting.xlsm 28.8 KB · Views: 3
Hi: Please find the attached. Change the combo box in sheet 1 , it will change both pivot and table filter . Thanks
S seanteo New Member Jul 28, 2015 #5 Hi Nebu, many thanks for your kind help. This workout is really helping to ease my pain a lot. Thanks again.
Hi Nebu, many thanks for your kind help. This workout is really helping to ease my pain a lot. Thanks again.
