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