Hey There,

I'm not sure if what I am tring to do here is even possible, but I am hoping that it is.

I have a list of data in Columns A through O and from Rown 1 to 1028. I was given a Macro a little while ago (thanx again! ) that goes through rows 22 to 1021 and hides all of the Rows where neither Column K nor M have a value.

What I am hoping for now if a Macro that will look at what is left and break it down into 35 Row blocks, so to say. What this Macro would is repeat Rows 1 thorugh 21 at the top of each page, would add 35 of the unhiden rows below that on each page, and on the last page would tack on rows 1022 through 1028.

I'm not sure I am explaining that well, so let me give you an example. Lets say the first Macro runs and leaves 66 valid Rows. This Print Macro would then break it down into two pages:
* The first page would have Rows 1 through 21 and the first 35 of the 66 lines remaining between Rows 22 and 1021.
* The second page would also have Rows 1 thorugh 21, followed by the remaining 31 Rows from the middle, and would add Rows 1022 to 1028 at the bottom.

As an added bonus (but not required), it would be nice if each page had a Sub-Total of the page as well, including the last page (inbetween to last Rown from 22 to 1021 and the 1022 to 1028 Rows).

Make sense?

You guys ROCK!! Thanx again for all the amazing help!