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!!
Bookmarks