Solved: Adding sourcedata to Pivottable

[vosmerkin]

Hello
I have workbook with 3 (for now) sheets. First contains PivotTable. Source ranges for this table are on each of the other sheets. Each month new sheet appears. I need to update data sources for PivotTable.

Please advice

[dominicb]

Good morning vosmerkin

I assume that you're using the Multiple consolidation ranges option on the pivot table menu? If so, right click on your pivot table and select pivot table wizard from the menu. Click on Back, and it will bring up the dialog that allows you to add an extra range to your table.

HTH

DominicB

[vosmerkin]

Hi, thanks for replay. I needed to do it with code. I've already found solution

pv.SourceData = sd

where sd is variant to dimensional array with ranges and its names (as I want to se it in pivottable)