insert data after page break

[rshintz]

I need to insert header files at top of each page break

Setup as follows:

ABC Company
Payroll
Pay Period 24 ending 11/21/09

Account Business Office:

DEPT EMP.NBR EMPLOYEE NAME SHOP QTY

883 12345 CHICKEN LITTLE FRAME 54
883 78913 SKY FRAME 75

883 TOTAL 129

----------------------------------------------------------------
932 27946 LUKE SIGNS 18
932 25139 MARVIN SIGNS 11

932 TOTAL 29

------------------------------------------------------------------
I need to add after page break plus insert a row
Account Business Office:

DEPT EMP.NBR EMPLOYEE NAME SHOP QTY

can anyone help me

 

[lenze]

From you example, it appears you want to repeat rows 5-7. So,
File>PageSetUp>Sheet Tab
Rows to repeat
$5:$7
Click OK

lenze

 

[rshintz]

I can not do that because I already have report data to print on each page, these are data lines I am going to add data to with a vlookup.