View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
AQ Mahomed AQ Mahomed is offline
external usenet poster
 
Posts: 10
Default Copy Rows and insert these rows before a page break

Hi


I have approx 500 pages to print, As you all know excel cannot repeat
rows at the bottom of each page.
I need to move to every page break insert 5 rows before a page break ,
go to the next sheet copy the 5 rows from the next sheet and paste this
information into the inserted rows then go to the next page break and do
the same until the last horizontal page break is complete.

Thank
AQ


*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!