dentcastlemore
New Member
- Joined
- Mar 26, 2015
- Messages
- 1
Hi,
I have a worksheet that I have inserted page breaks for to separate accounts (using subtotal). I now need to print it double sided, but if a group from one account ends on an odd page, the next group will start on backside. I need to file all accounts individually, so I need blank pages to sometime go after odd pages so that a new group of data begins on new sheet. It's about 40,000 rows, and separating by hand will take too long. Also, I have a header I'd like on all pages with data. I've tried re-organizing data, separating to sheets (too many), counting rows, looking for page break formulas, and using macros I've found elsewhere. No luck. I'd appreciate any advice, including "this won't ever work, start doing it by hand".
Thanks
I have a worksheet that I have inserted page breaks for to separate accounts (using subtotal). I now need to print it double sided, but if a group from one account ends on an odd page, the next group will start on backside. I need to file all accounts individually, so I need blank pages to sometime go after odd pages so that a new group of data begins on new sheet. It's about 40,000 rows, and separating by hand will take too long. Also, I have a header I'd like on all pages with data. I've tried re-organizing data, separating to sheets (too many), counting rows, looking for page break formulas, and using macros I've found elsewhere. No luck. I'd appreciate any advice, including "this won't ever work, start doing it by hand".
Thanks
