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!