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:
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
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