Need to add header and footers in Excel

[rustym]

Hi everyone,

I am working on a workbook right now that has a big table in which I need to keep pasting entries into with a macro. The problem is that the table may be several pages long and I need to include the headers and a footer for the table on every sheet.

The idea is that I have a for loop that keeps pasting data into the table but when it realizes that there is only one row left before the footer, it should paste the next entry in the next sheet (under the headers) and skip the footer in the latter page.

In Word you can do this with page breaks, but it seems much harder to do in Excel.

Any ideas on how I can achieve this?

Thanks in advance,

rustym

 

[jbeaucaire]

Go into FILE > PAGE SETUP > SHEET > PRINT TITLES and set the rows that are to be repeated at the top of every sheet.

Then click on the HEADER/FOOTER tab and set your custom footer.

 

[rustym]

It worked great thank you!!!!