Update all pivot tables based on 1st

[spbready]

I have an excel file that contains 7 pivot tables based off of information from an Access database. I would like for the 6 other pivot tables to change based off of options chosen for the first one. The column heading for all pivot tables is Date & the row heading is Rep. The first cell for each table is B20, B59, B100, B121, B142, B163, B184.

I'm sure that I'll need VBA code to accomplish this but obviously have no clue where to start.

I appreciate any help.

[Cheeky Charlie]

This is the core:

Sub RefreshPivots()
Dim ws As Worksheet
Dim pt As PivotTable

For Each ws In ActiveWorkbook.Worksheets
    For Each pt In ws.PivotTables
        pt.PivotCache.Refresh
    Next pt
Next ws
End Sub

It could be changed:
perhaps triggered via workbook-level worksheet pivot table update event
depending on location, 'activeworkbook' could be changed to 'me' or removed altogether

It has taken a while to get a reply because you've posted in a forum on worksheet functions. If you are more careful with which forum your thread belongs in, you will get a better response.

CC

[DonkeyOte]

Thread moved to Programming Forum.