Inserting PageBreak via a cell or group of cell constraints.

[Jvalades]

Hello Excel world.

So I have a very big list of (for this example lets call them) locations.

See example:

[TABLE="width: 110"]
<colgroup><col></colgroup><tbody>[TR]
[TD]01 02 A[/TD]
[/TR]
[TR]
[TD]01 05 A[/TD]
[/TR]
[TR]
[TD]01 05 B[/TD]
[/TR]
[TR]
[TD]01 06 A[/TD]
[/TR]
[TR]
[TD]01 06 B[/TD]
[/TR]
[TR]
[TD]PAGE BREAK[/TD]
[/TR]
[TR]
[TD]02 01A[/TD]
[/TR]
[TR]
[TD]02 01B[/TD]
[/TR]
[TR]
[TD]02 05A[/TD]
[/TR]
[TR]
[TD]02 05B[/TD]
[/TR]
[TR]
[TD]02 06A[/TD]
[/TR]
[TR]
[TD]02 06B[/TD]
[/TR]
[TR]
[TD]PAGE BREAK[/TD]
[/TR]
[TR]
[TD]03 01 A[/TD]
[/TR]
[TR]
[TD]03 01 B[/TD]
[/TR]
[TR]
[TD]03 02 A[/TD]
[/TR]
[TR]
[TD]03 02 B[/TD]
[/TR]
[TR]
[TD]PAGE BREAK[/TD]
[/TR]
[TR]
[TD]ELA011[/TD]
[/TR]
[TR]
[TD]ELA012
PAGE BREAK
ELA110
ELA112[/TD]
[/TR]
</tbody>[/TABLE]

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

 

[Jvalades]

Bump