I have a large sheet that I am converting from monthly into annual data using a series of sumif calls from the monthly worksheet into the annual worksheet.

The main monthly worksheet is horizontally oriented, so year one is in column b, year two is in column c, and so on.

I have a title on the first page found in row 1 and I have row headings within column A...is there a way to have both the title and row headings repeat on each page using the Page Set up dialogue box? Can a Pivot Table do this for me?

Any and all help is much appreciated.