S
Stanley Braverman
I have a worksheet with over 300 pages that I need to print.
However the second page can be copied and pasted to the
first page to the adjacent columns and the page layout would work fine.
What I need is a macro to take page 2 and automatically
paste it to page 1 then delete the page 2 info and move up
the empty spaces from the worksheet and then continue
the process till all pages has been done.
In other words:
Page 1 plus page 2 now equals page 1
Then after moving up cleared cells
Page 2 and page 3 now equals page 2 (formally page 3 and 4)
Then after moving up cleared cells
Page 3 and page 4 now equals page 3 (formally page 5 and 6)etc..etc.etc
Involved are 4 columns for page 1 then 5 additional columns
for the new page to be added.5th column would be spacer
I can handle the spacing of the coulombs and rows and resizing the page
widths.
Thanks
However the second page can be copied and pasted to the
first page to the adjacent columns and the page layout would work fine.
What I need is a macro to take page 2 and automatically
paste it to page 1 then delete the page 2 info and move up
the empty spaces from the worksheet and then continue
the process till all pages has been done.
In other words:
Page 1 plus page 2 now equals page 1
Then after moving up cleared cells
Page 2 and page 3 now equals page 2 (formally page 3 and 4)
Then after moving up cleared cells
Page 3 and page 4 now equals page 3 (formally page 5 and 6)etc..etc.etc
Involved are 4 columns for page 1 then 5 additional columns
for the new page to be added.5th column would be spacer
I can handle the spacing of the coulombs and rows and resizing the page
widths.
Thanks