Excel question (Programming multiple Pivot Tables)

Discussion in 'OT Technology' started by Slash, Jun 11, 2009.

  1. Slash

    Slash New Member

    Jun 2, 2004
    Likes Received:
    So.. I've got a data sheet, and a "report" sheet. On the report sheet there are about 18 different pivot tables to compile a 3 page report.

    I want to be able to switch the PAGE field of the pivot tables (all of them) at the same time, to the same value.

    For example. Report for "Owned" sales would switch all the page fields to "Owned", or for "Consigned" it would switch all of them to "Consigned" automatically.

    Do I have to use the developer drop down buttons? What do I need to do. I consider myself moderate to advanced in excel but I know very little VB.

Share This Page