Hi I need your help!!!
I am trying to re-create my PivotTable with Multiple Consolidation Ranges via VBA in order to automate some repetitive tasks. I have recorded macro while creating my PivotTable which get data from ~50 sheets ranges, within the same workbook.
Here is the sample:
But, when I try to alterate the SourceData: I get nasty error "Run-Time Error 1004" Cannot Open PivotTable source file.Please Login or Register to view this content.
I've tried noumerus ways to rewrite/read the A1 cell value without any effect.Please Login or Register to view this content.
Thank you in advance.
Bookmarks