Copy Rows and insert these rows before a page break

A

AQ Mahomed

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting a page break to take 0
Page Break when a column changes 4
Page Break Problem 0
Cut bottom 300 rows to next sheet & repeat 8
Page break code - hpagebreak before value 3
Setting and removing page breaks 2
Page break dosen't break 4
NEED TO REPEAT ROWS AT THE BOTTOM OF EXCEL SPREAD SHEET 5

Top