i already have my code that works fine if i keep the index on the same page as the pivot but i am trying to get it to look at another cell in a different worksheet
the code i have got already that works is this
Sheets("PVT").Select
ActiveSheet.PivotTables("PivotTable6").PivotFields("Project Name"). _
ClearAllFilters
ActiveSheet.PivotTables("PivotTable6").PivotFields("Project Name").CurrentPage = Range("A1").Text
but where i have - .currentpage = range("a1").text - i want it to pick up from a the sheet called summary
ive tried replacing the info with sheets("summary).Select CurrentPage = Range("a1".text but doesnt work
can you help
thanks
Bookmarks