I have a spreadsheet that has 5762 rows, I would like to add a page break after a certain condition. Here is what i would like to do:
I have 3 columns, the numbers below are under column A or "Item Numbers", I would like to add a page break after 1020038 as well as an empty row so i can put my headers under that series of numbers, that way when i export the list to a pdf I would know what i am looking at. The numbers are not consistent and change. I have a few numbers that look like this: B261-92 as well as. One thing is that the first 3 numbers or first letter followed by 3 numbers are considered one set. Example is the B261-92 that group also has B261-167,31,64,66, etc. So if i can get a page break after B261 as well as a a new row that would be amazing. ANY HELP IS APPRECIATED. THANK YOU
ITEM NUMBERS
<colgroup><col></colgroup><tbody>
</tbody>
I have 3 columns, the numbers below are under column A or "Item Numbers", I would like to add a page break after 1020038 as well as an empty row so i can put my headers under that series of numbers, that way when i export the list to a pdf I would know what i am looking at. The numbers are not consistent and change. I have a few numbers that look like this: B261-92 as well as. One thing is that the first 3 numbers or first letter followed by 3 numbers are considered one set. Example is the B261-92 that group also has B261-167,31,64,66, etc. So if i can get a page break after B261 as well as a a new row that would be amazing. ANY HELP IS APPRECIATED. THANK YOU
ITEM NUMBERS
| 1020025 |
| 1020035 |
| 1020038 ITEM NUMBERS |
| 1030025 |
| 1030087 |
| 1030088 |
| 1030094 |
| 1030096 |
| 1030098 ITEM NUMBERS |
| 1040021 |
| 1040035 |
| 1040038 |
| 1040039 |
<colgroup><col></colgroup><tbody>
</tbody>
