Hi.
I have three pivot tables that use/display different data that is pulled from a database. The data has a number of discriptions along the left hand side and dates along the top. The data displayed is simply the item (ex. assets) and the corresponding value for the dates selected along the top. Think of a balance sheet from a financial report.
Is there a way that when I select the dates on the first pivot table the other 2 will automatically chose the same dates as well? There are a lot of dates so I am trying to avoid a double 'for each' VBA statement because it takes forever the run on my computer.
thanks in advance.
B
I have three pivot tables that use/display different data that is pulled from a database. The data has a number of discriptions along the left hand side and dates along the top. The data displayed is simply the item (ex. assets) and the corresponding value for the dates selected along the top. Think of a balance sheet from a financial report.
Is there a way that when I select the dates on the first pivot table the other 2 will automatically chose the same dates as well? There are a lot of dates so I am trying to avoid a double 'for each' VBA statement because it takes forever the run on my computer.
thanks in advance.
B