Updating pivots in different sheets with same source

sh1ne

New Member
Joined
Jul 3, 2017
Messages
33
Office Version
  1. 2016
Platform
  1. Windows
Hello,
someone can help me? It's a little bigger thing, let me describe the problem. Need to write macro which will be changing data source for 10 pivots in 10 different sheets. The data source and range will be same for all pivots. I just need the body of macro, dont need the procedures which will be skipping sheets. Need to automatize it, before Ive just recorded a macro where I use the PivotTableWizard and it was working, but need to automatize it. There is code from recorded macro:
Code:
 ActiveSheet.PivotTableWizard SourceType:=xlDatabase, SourceData:= _
        "'\Filepath[Filename.xlsb]DataTab'!R1C1:R[COLOR=#ff0000]1234[/COLOR]C79"
    ActiveWorkbook.ShowPivotTableFieldList = True

There is any option to show something liek MsgBox which allows us to choose file? The next problem is that text marked as red, because it will be last row from that tab, should I use global variable or just exact from user this last row and use it as variable?


Sorry for my chaotic eng, hope you will help me. Thanks


 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Forum statistics

Threads
1,223,911
Messages
6,175,337
Members
452,637
Latest member
Ezio2866

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top