This is a VBA issue ........I have an Excel spreadsheet that has numerous lines of data per Branch Number......I want to insert a page break at the end of each different Branch Number so that different people can receive individual Branch information.

Using VBA code, how can i insert a pagebreak between different Branch Numbers ???
i.e Branch 1 on one page....Branch 2 on the next...etc,etc

All Branch Numbers are in column A


thanks, in advance