Creating a persistent format across several pages

Ok, I'm essentially creating a basic table and I have my first page created exactly how I want it. Header, footer with page numbers, and the main page consists of a table with borders, column headers, and every other row highlighted. I'm making the table for a small company to record the results of equipment tests that they have to run every morning. What I need it to do is to keep that format on every new page that gets activated. The users of this particular form that I'm making are not particularly computer savvy, so asking them to recreate the table everytime they need a new page would be asking quite a bit. Thanks.

Perhaps create a template sheet within the workbook that has everything laid out properly minus any data. Then hide that sheet.

Now record a macro of you unhiding the sheet, copying it to a new sheet at the end of the workbook, then hiding the template sheet again.

Show your people how to add a sheet by simply running the macro.

If you post the name of the template sheet, plus any requirements you might want to add such as having the macro ask for new sheet name, or anything else, and post that in the programming forum, the guys watching that forum would probably make a slick macro for you if you're not happy with the results of your recorded macro.

http://www.excelforum.com/excel-programming/

Give this a try as a macro, just edit the "sheet3" references to the name of the template sheet you're going to keep hidden.

Please Login or Register  to view this content.

Maybe ...

Please Login or Register  to view this content.

What you want is easy enough -- I just don't know what it is, sorry.

Want to start at the beginning?

What I need to happen is when I move onto page 2 it automatically replicates the table of page 1..ditto when I move onto page 3..etc.

1. How many sheets do you want to begin with?

2. What event causes a new sheet to appear?

want the next printed page, within my active worksheet, to be created when data table on the current page is filled up.

What does "filled up" mean? When G44:K44 contains five entries?

OK, put this in the sheet module for Step Wedge Test:

Please Login or Register  to view this content.

If you're happy, I'm happy.

Now that I understand what you want, it's as simple as copying the row formatting down to the end of the worksheet, and setting heading rows repeat to the first couple of rows.

In the Worksheet_Change event, set the print area to include the last data entry.

If you have when you want with your approach, fine.