Multiple Range Pivot Table

[chalky]

I have two ranges of data with the same headings. One range will
continuously have data added to it each month, where the other is a
static row of data that gets changed each month. I need to pivot both
ranges together but i dont want to add in the static data to the
variable each month only to have to delete it out again.

Is there away of doing this?

Thanks
Chris

 

[Debra Dalgleish]

You could create a dynamic named range, as described here:

http://www.contextures.com/xlNames01.html

Then use that name in the PivotTable Wizard, when selecting the multiple
ranges.