Page Layout

[Adam Clark]

Thanks to Bob and Tom for their help with my last
post....much appreciated.

My next question:

I have a template set out as below

Date:
Supplier Ref:
Supplier name:
Transfer no:
Payment Total:

---------------------------------------------------
Inv Date Inv Number Curr Amount

data goes here







--------------------------------------------------
I paste in values from another workbook with a macro. This
works fine when the data I copy in spans less than one
page but if it is greater than one page the data runs onto
a new page. This doesnt look very professional as there
are no row headings ie: inv date, inv number, curr and
amount and the -------- also doesnt appear.

I cant incorperate the headings into the worksheets header
as it has formulas in it.

What I was think was to add the headings into say 10 pages
(which will probaly be the maximum I would need) and then
only display pages I need.

Does anyone know how to do this or have any workarounds?

Thanks so much for your patience reading this.

 

[Tom Ogilvy]

Have you looked at Rows to Repeat at top in the last tab of the page setup
dialog?