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


--
chalky
------------------------------------------------------------------------
chalky's Profile: http://www.excelforum.com/member.php...o&userid=23758
View this thread: http://www.excelforum.com/showthread...hreadid=484273