page break formatting help
Posted by gene rodriguez on December 25, 2001 6:12 PM
I have a web based report that prints out records of data. There is a link that I can click on to convert the report to an excel spreadsheet.
The one problem I have is that I always have to go back into the spreadsheet and adjust the page breaks. Is their a way of having excel identify the records and page break only at the end of a record? Records vary in length anywhere from 5 to 8 rows and are separated by borders.
Can I acheive this by a macro or some other method?