Hia Everyone,
I'm using a workbook that contains 3 pivot tables. One field in all pivot tables is the same. I would like to create something like a list box on the first worksheet that feeds to this field of the pivot tables.
The idea is that a user can select an item from a list box on the front sheet which will then change the field setting of all the pivot tables in the workbook and refresh them.
I figured I could set up a button on the first sheet that when a user clicks it, a macro will activate that takes the value selected from the list box, feeds it to the pivot tables and updates them all.
I recorded a macro that I thought would do the job but it doesn't!
ActiveSheet.PivotTables("PivotTable2").PivotFields("BB").CurrentPage = Range("I7").Select
I intended the pivot table to look in cell I7, change pivot filed BB to this value and then refresh.
Any ideas? Maybe a macro isn't needed for this and it can be done in regular pivot table settings?
Cheers...Alkemist
I'm using a workbook that contains 3 pivot tables. One field in all pivot tables is the same. I would like to create something like a list box on the first worksheet that feeds to this field of the pivot tables.
The idea is that a user can select an item from a list box on the front sheet which will then change the field setting of all the pivot tables in the workbook and refresh them.
I figured I could set up a button on the first sheet that when a user clicks it, a macro will activate that takes the value selected from the list box, feeds it to the pivot tables and updates them all.
I recorded a macro that I thought would do the job but it doesn't!
ActiveSheet.PivotTables("PivotTable2").PivotFields("BB").CurrentPage = Range("I7").Select
I intended the pivot table to look in cell I7, change pivot filed BB to this value and then refresh.
Any ideas? Maybe a macro isn't needed for this and it can be done in regular pivot table settings?
Cheers...Alkemist