Multiple condition page break

[derekjae]

I have a Worksheet that I import a CSV file into and then use vba to format. the first column has a date and time format which can consist of multiple days (ie. 3/11/2025 13:21 and 3/12/2025 17:56) I need to have each day have its own page and each page can only have 25 rows. a page can have less rows but no more than 25. I can write up a code to page break at 25 but not sure how i can page break by date and 25 rows per page. any help would be greatly appreciated.

Thank you

 

[bobsan42]

Post whatever code you come up with so someone here can help adjust it.
And you may also post some sample data (using Xl2bb) for testing.