Pivot Table

[psamu]

I would appreciate if someone help me, I have pivot table in Sheet1 and below code works fine,
ActiveSheet.PivotTables("PivotTable3").PivotFields("Fiscal Year").CurrentPage = Range("E4").Text

but when I put second pivot table in Sheet2 and I have below code, it gives me error.


Sheet2.Select PivotTables("PivotTable5").PivotFields("Fiscal Year").Sheet2 = Range Sheet1.("E4").Text


Based on report filter sheet 1 Pivot table on sheet 2 report filter need to change. thanks

 

[VoG]

Is it?

Sheet2.PivotTables("PivotTable5").PivotFields("Fiscal Year").CurrentPage = Sheet1.Range("E4").Text

 

[psamu]

Thanks a lot. It works fine now.