Need help with dynamic page breaks.

Hi
The result I need is in column LV and was manually entered.

Column LW are groups of matching numbers and each group is separated by a decimal number.
The groups will change size.

LV and LW are helper columns and my goal is to print sheets without breaking a group of numbers.

Each sheet is 56 rows.
The count in LU will try to reach 56 but it cant end in the middle of a group of matching numbers in LW.
The count always ends at a decimal number. The next row will start at 1 again

Every number 1 will represent a page break. I have the code that will put a page break at each number 1

In my example, the count stopped at 48 and the next row started at 1 again.

Boy I tried hard to have this make sense.

I would prefer formulas but VB is ok!

File attached

I appreciate you!

What about in Cell LV4 and copied down

Please Login or Register  to view this content.

Hi
The formula is appearing as text when I paste in LV
weird

I typed it in and it worked. The results look good. I'm going to try a few things and get back to you.

I see that it seemed to work because of the static value of 48. The formula needs to be dynamic as the values in LW are never the same.

I did attach an example in my original post but not with the results from the formula. I can do that.

From your last attachment, I am not entirely sure how it is 'incorrect'. You have 4 columns LT:LW
LT(orange) - marked Incorrect
LU(blue) - Suggested Formula is marked 'incorrect'
LV(green) - 'Correct'
LW(black) - helper column

LU and LV are exactly the same. Not sure exactly what is wrong. How about uploading the actual spreadsheet(removing sensitive data)