Excel report from my finance system exports with no page breaks. How do I insert a page break after every instance of "ENDING BALANCE" so that I can separate the report by account? Would not like to use macros as I would need this to be available to others in case someone else needs to run the report. Cannot currently use sort or filter because of the way the report exports.
A B C D


1 Account name ART
2 Beg Balance $100
3
4 Receipts Fees $20
5 Fees $20
6
7 Ending Bal. $140
8
9 Account name MUSIC
2 Beg Balance $100
3
4 Receipts Fees $20
etc etc etc

I found the answer by pasting my report into Word