View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Print a number of rows per page

Hi
see your post in Excel.misc


--
Regards
Frank Kabel
Frankfurt, Germany


girapas wrote:
I have an Excel workbook with 2 sheets. One of them is for data
entering (e.g. rows: employee's name, ID#, working dates, fee etc.)
and the other presents that data among other constant value cells
(e.g. name of company, titles of columns, place for signatures etc.).
What I want is when data in the presentation sheet reach at 22 rows
to be automatically continued to the next page of the sheet. So, each
printed page will always shows 22 rows of data with the constant data
ABOVE and BELOW of these 22 rows. Thanks,