Formatting a pivot worksheet to display a string at the end!
 

Hi there,

I have created several worksheets using the 'Show Pages' function, but
now need to add a bit of blurb underneath each of the pivot tables.

I was thinking of doing this in the Page Footer, but this will be
displayed on every page - and some worksheets will span several pages.

Can anyone tell me if there is an easy and quick way of adding some
text to the end of the pivot tables in every worksheet (there are 50
worksheets!)

thanks in advance,
Matt


--
matpj
------------------------------------------------------------------------
matpj's Profile: http://www.excelforum.com/member.php...o&userid=21076
View this thread: http://www.excelforum.com/showthread...hreadid=500564

Formatting a pivot worksheet to display a string at the end!
 

Hi,
Have a look at this page of Ron's Debruin's,
http://www.rondebruin.nl/print.htm#Header, about 3/4's of the way down
is a section titled "Do not print Header or Footer on all pages". This
may give you a good starting point.

hth,
Rob Brockett,
NZ
Always learning & the best way to learn is to experience...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=500564