I have a workbook that contains around 14 worksheets - static data, Year overview, and 12 monthly worksheets.

The 'year overview' worksheet contains a row for each date of the year. However, each date will contain a minimum of 2 rows per day, but can go up to around 6 rows for any given date. Therefore this worksheet can contain around 1000 rows.

For each of the 12 monthly worksheets, the data for say, May, is copied onto its respective monthly worksheet.

What I am trying to achieve is to automatically implement page breaks on the 'Year Overview' and each of the individual '12 monthly' worksheets - say after row 15(variable if possible). This could be day 7 or day 8 for that month depending on the number of rows added for any given day(s).

I also want to ensure that no date is split across the page break.

Can you please assist in providing automation to automatically add page breaks after nn rows and ensure that no date is split across a page break.

I thank you in anticipation.


Col. A contains the date


Col. B to ?. data from static data worksheet