Removing group of repetitive rows from large excel file.
Posted on 2007-10-19
I have to prepare some files for our friendly neighborhood auditor. These files are generated by our month end procedure in Accpac Plus for DOS.
Two files are generated: an AP (purchases and expenses) file and a OE (sales) file.
Basically what I need to do is take these 24 total text files and open them with Excel and set them up so totals for GL accounts can be viewed easily etc etc.
My problem is that Accpac generates these files with page headers. Each file must have at least 100 pages so when I open them in excel I get the date, page number and column headers every 60 rows or so.
It wouldn't be so bad if these page headers occupied a single line but they span about 8 or 9 lines.
What's the quickest and least painful way I can remove these lines either in Notepad, Word or Excel?