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>
G00015 NH2187P1/144<br>
G00016 NH2187P1/144<br>
G00017 NH2187P1/144<br>
G00018 NH2187P1/144<br>
G00019 NH2187P1/144<br>
G00020 NH2187P1/145<br>
G00021 NH2187P1/145<br>
G00022 NH2187P1/145<br>
G00023 NH2187P1/145<br>
G00024 NH2187P1/145<br>
<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)
## Deliverables
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.
## Platform
Windows, excel