Hello,

First post so go easy on me haha but here's my situation.
-
Every week I have to download a data set that has dates associated 3 weeks of data, but is done every Friday so it'll change dates each week (5/23/2014 - 6/06/2014 and then next week it will be 5/30/2014 - 6/13/2014).

I have the tables refreshing and updating automatically by recording a macro, but I cannot seem to get it to select the new dates because they are changing every week. One Code I found from another thread demonstrated how to change only 1 value based on a name range, but I was wondering how I could change multiple (7 ideally).

This is the code:

Sub Test()

Dim pt As PivotTable
Set pt = Worksheets("Pivot").PivotTables("PivotTable1")

pt.PivotFields("Date").ClearAllFilters
pt.PivotFields("Date").CurrentPage = Range("Date1").Value

End Sub

Thank you for your help!!