<div>
In 2007 you can use only VBA (macro) for this. If you can use Office 2010 or 2013 there is a feature called Slicers which is somethig you can use for this
</div>


In 2007 you can use only VBA (macro) for this. If you can use Office 2010 or 2013 there is a feature called Slicers which is somethig you can use for this

<div>
Sorry, for now, IT has only allowed us to use 2007. Given such, what is the VB macro I can use?
</div>


Sorry, for now, IT has only allowed us to use 2007. Given such, what is the VB macro I can use?

<div>
<div class="content wysiwyg-content">
I have two tabs with a pivot table each in an MS Excel 2007 spreadsheet from the same data source. &nbsp; Specifically, I have date (MMMYYYY) filter at the top of the 1st tab and another Date filter on the second tab.<br />
<br />
How do I connect the two. &nbsp;I.e., if I select a date in the 1st tab, say AUG2014, how can I relay that select to the pivot table in the second tab?<br />
<br />
Thanks,
</div>
</div>


I have two tabs with a pivot table each in an MS Excel 2007 spreadsheet from the same data source.   Specifically, I have date (MMMYYYY) filter at the top of the 1st tab and another Date filter on the second tab.

How do I connect the two.  I.e., if I select a date in the 1st tab, say AUG2014, how can I relay that select to the pivot table in the second tab?

Thanks,

Two Pivot Tables, one dependent on the other

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.