Pivot tables autofilter

  • [INDENT]On sheet 1 i filtered my database on "vendor list". On sheet 2 i created a pivot table in which "vendor list" is set as a field. I wished that if i select and filter out a particular value from "vendor list" in sheet 1 ,the "vendor list" field on sheet 2 will automatically filters out the same value . Is this possible?
    If someone can provide me with the right code i will be veryyyy thankful.

    Thank you for your answers.

  • Re: Pivot tables autofilter

    I am not supposed to touch the pivot table. I have only access to the master table filter and i have to control the data in the pivot table from that master table (sheet 1).

    any new suggestions??

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!