troubleshooting Question

Formatting a worksheet for printing

Avatar of dwe0608
dwe0608Flag for Australia asked on
Microsoft Excel
15 Comments1 Solution293 ViewsLast Modified:
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


Darrin example.xls
Saqib Husain

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 15 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 15 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros