• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to activate filters of a Pivot table & a normal table of data via 1 combo box ?

S

seanteo

New Member
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 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:

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 Nebu, many thanks for your kind help.
This workout is really helping to ease my pain a lot.
Thanks again.
 
You must log in or register to reply here.
Back
Top