Formatting a worksheet for printing

Hi Guys

I have a formatting question .... I have a sheet with approximtely 3000 rows of data. This prints nicely on A4 paper. I can use the header and foot functionality to print the spreadsheet with headers and footer. But I need to print the headers and footers like a bank statement, with carried forward balances on the top and bottom of each page

The way I see it working is to have a row inserted at the top of each page, with the requisite information in it. For example, I see a worksheet in front of me with Page Break View on - the program knows where the top and bottom of each page is - I need to programmatically insert a row, and fill in the carried forward and balance details at the top and bottom of each page (except the first which would have only a balance at the bottom.

Does that make sense? I would like to use VBA on this.

An example of what I would like the doucment to look like is attached. The green coloured cells are what I would imagine would be inserted by the VBA code

MTIA

Darrin example.xls