You could create a dynamic named range, as described he

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

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

chalky wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html