I have a worksheet with 6 pivot tables linked to an Access database. Each pivot table is filtered for a particular month. I do this manually every time. Is there a way this could be done automatically with a macro? <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
For example I if I enter 06/01/2009 on a cell then, the first pivot would be filter for 06/01/2009, the next for 05/01/2009, the next for 04/012009 and so on.<o></o>
<o></o>
Any help would be appreciated it.<o></o>
Thanks!!
<o></o>
For example I if I enter 06/01/2009 on a cell then, the first pivot would be filter for 06/01/2009, the next for 05/01/2009, the next for 04/012009 and so on.<o></o>
<o></o>
Any help would be appreciated it.<o></o>
Thanks!!