M
Mike Saffer
Hello everyone,
I not sure if there is such a thing but here goes.
I'd like a page break each time the first 4 characters of a value changes in
Column A. To make my problem even harder for me is that there are blank
cells in Column A. Finally, to make my problem impossible for me is that the
page breaks would have to skip the final blank cell in a group and break just
below it. It's difficult to explain but I hope the example below helps
clarify what I'm saying.
Here's what I have:
A
Starke
Starke
Starke
(blank cell)
St Augstine
St Augustine
(blank cell)
St Augustine 2
St Augustine 2
(blank cell)
St Johns
St Johns
(blank cell)
Here are the desired results
A
Starke
Starke
Starke
(blank cell) with page break just below
St Augstine
St Augustine
(blank cell)
St Augustine 2
St Augustine 2
(blank cell) with page break just below
St Johns
St Johns
(blank cell) with page break just below
St Augustine and St Augustine 2 are in the same group because the first 4
characters did not change. I have to keep the blank cells intact.
Can this be done with code? Many thanks for looking,
I not sure if there is such a thing but here goes.
I'd like a page break each time the first 4 characters of a value changes in
Column A. To make my problem even harder for me is that there are blank
cells in Column A. Finally, to make my problem impossible for me is that the
page breaks would have to skip the final blank cell in a group and break just
below it. It's difficult to explain but I hope the example below helps
clarify what I'm saying.
Here's what I have:
A
Starke
Starke
Starke
(blank cell)
St Augstine
St Augustine
(blank cell)
St Augustine 2
St Augustine 2
(blank cell)
St Johns
St Johns
(blank cell)
Here are the desired results
A
Starke
Starke
Starke
(blank cell) with page break just below
St Augstine
St Augustine
(blank cell)
St Augustine 2
St Augustine 2
(blank cell) with page break just below
St Johns
St Johns
(blank cell) with page break just below
St Augustine and St Augustine 2 are in the same group because the first 4
characters did not change. I have to keep the blank cells intact.
Can this be done with code? Many thanks for looking,