New Page, not worksheet

[rs2k]

I have a form (Not userform) on a ws which when printed out fills out a A4 sheet of paper. Most of the time I have to copy and paste the form to keep the headings and borders in the correct place.

Is there a way of auto creating the template when the first page is full?

Cheers
Colin.

 

[iggydarsa]

If it is not a userform what kind of a form is it? Is it still within excel? Because if it is, you can "record macro" and keep running it everytime you need it.

 

[Nimrod]

Hello rs2k:
Are you just wanting to print the Header rows at the top of each page printed ? If so just specify this in ...

"File"... "Page Setup"... "Sheet Tab" ... "Rows To repeat at top" and/or "Columns to repeat at left ".

If this is not what you looking for could you please give a concrete example.

 

[rs2k]

Thank you for responding, I will try to explain a bit more. What I have is various boxes (cells) spread around a ws. The total area when printed out covers an A4 sheet, when it is printed out the user fills in the boxes with the relevant data. If the user has a lot of data, then a second sheet is printed out for them to fill in and so forth.
What I am asking is, if the user fills out the first page on screen (which some do) and needs a second page, they have to copy & paste the first page to keep all the data in the title boxes.

In the past I have used a MS Word document that when you completley fill the page and need a second page it automatically creates the template with all the headings and boxes in the correct place, this is what I am asking about, does Excel have the functionality to create new pages from existing templates?

If it is not possible, I think Iggydarsa suggestion is the way to go.

Thanks
Colin

 

[Nimrod]

rs2k:

In this situation I use a hidden "master Sheet". The Master sheet is the empty form. When I want a new empty form I just run a macro that .. 1) copies the hidden master 2) renames the copy 3) undhides the copy 4) make the copy active.

In fact I also use this same process when the user wants to clear a form . With the added step of deleting the filled old form. Since it's much faster , and less code , then clearing the old filled form. :wink:

 

[rs2k]

Cheers Nimrod. Following Iggydarsa suggestion I recorded a macro and it is on similar lines to your suggestion.

Thank you, to you both,

Colin.