Hi all,

I have a spreadsheet which summarises all the other sheets in the workbook based on a unique number. The summary sheet is broken down into various groups of data which could be 30 rows or 10 rows. If there is nothing in the other sheets relating to a unique number then it automatically hides that row from the summary sheet.

What I want to try and do is try and keep each group of data together when I print the sheet and a group not spread over two pages.

Is it possible to have a code run before the sheet prints that checks this and automatically places the page break in the right place? Also this report is different each time it is run so the page breaks would be different each time as well.

Any help would be much appreciated.