Filter several pivot tables by one programmed date range filter in Excel 2003

**olewka** · 08-08-2011, 10:50 AM

Hi all,

Please help.
Currently I am using programmed date range filter for pivot table in Excel 2003. I would like to make it work for several pivot tables on one spreadsheet coming from one data source. Does anyone have an idea how to make it work for several pivot tables at once?

Here is the code I am currently using:

Please Login or Register  to view this content.

**olewka** · 08-08-2011, 11:16 AM

here is the excel sheet with example

**Mordred** · 08-08-2011, 11:49 AM

Hi olweka, In the future please use code tags around you code as per Rule #3 of the forum rules (located in my signature). You used PHP tags instead of code tags. I have edited your post to include code tags so no worries but like I said, in the future please use code tags for VBA code. Thank you.