We need a macro that scans through an excel file, and inserts pagebreaks. The file is sorted on the fields "TAPE" and secondly on "Line No:". The fields contain data similar to this:
TAPE: Line No:<br>
We need a macro where we can enter a tape number to start from, and then the macro should scan through the file and insert page breaks every time the "Line No:" value changes. (Ex. insert pagebreak after tape G00019)
The macro is from here on called a program. Deliverables listed below.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Brief installation and operating instructions
3) Complete ownership and distribution copyrights to all work purchased.