Hello Excel world.
So I have a very big list of (for this example lets call them) locations.
See example:
<colgroup><col></colgroup><tbody>
</tbody>
The list goes on and on and on. I am trying to write a vba code that will search through a specific column and insert page breaks after each group of "Locations".
As you can see each group seems different in its own way. Some groups change by (Ex. a group = "ELA 0-99" or "ELA 100-199") different constraints.
Can I perform either a VBA macro or something to help simplify this process?
Thank you for your help and let me know if I can clarify the question.
J
So I have a very big list of (for this example lets call them) locations.
See example:
| 01 02 A |
| 01 05 A |
| 01 05 B |
| 01 06 A |
| 01 06 B |
| PAGE BREAK |
| 02 01A |
| 02 01B |
| 02 05A |
| 02 05B |
| 02 06A |
| 02 06B |
| PAGE BREAK |
| 03 01 A |
| 03 01 B |
| 03 02 A |
| 03 02 B |
| PAGE BREAK |
| ELA011 |
| ELA012 PAGE BREAK ELA110 ELA112 |
<colgroup><col></colgroup><tbody>
</tbody>
The list goes on and on and on. I am trying to write a vba code that will search through a specific column and insert page breaks after each group of "Locations".
As you can see each group seems different in its own way. Some groups change by (Ex. a group = "ELA 0-99" or "ELA 100-199") different constraints.
Can I perform either a VBA macro or something to help simplify this process?
Thank you for your help and let me know if I can clarify the question.
J
