Keep Rows Together

[taxstar]

I have a worksheet that currently has about 250 sets of data, each set utilizes 40 rows. I use autofilter to 'hide' irrelevant rows, leaving sets of data with anywhere from 5 to 40 visible rows - and, of course, the sizes of each set of data will change each month.

When I print the report, I need to make sure that there is no page break within a visible set of data, but still want to conserve paper (so the option of one set per page is a non-starter).

There's a "keep lines together" option in Word, but nothing similar that I've been able to find in Excel.

I thought I could build a 'visible row counter' in a non-printing column, but I can't figure out how to use the results to force a page break. Any ideas would be appreciated.


Taxstar

 

[Sal Paradise]

Set a max amount of lines you want on a page. Then create a 'group' column (or if you can tell in another way, that's fine too). Make a macro to loop through your sheet, and if a group is under that limit, you check the next group. If the sum is too big for the line limit, you only print the first group, otherwise you see if you can tack on a third as well.