kelly mort
Well-known Member
- Joined
- Apr 10, 2017
- Messages
- 2,169
- Office Version
- 2016
- Platform
- Windows
My data starts from Column A2 to J1002
So column C has the criteria say "x", "y", "z", etc.
These criteria are sorted so they are grouped.
That's all x all y all z in that order.
So I want to insert a blank row after the last x, then a blank row under the last y in that order.
Row 1 is the header
I am looking for a vba solution to this.
Thanks in advance
So column C has the criteria say "x", "y", "z", etc.
These criteria are sorted so they are grouped.
That's all x all y all z in that order.
So I want to insert a blank row after the last x, then a blank row under the last y in that order.
Row 1 is the header
I am looking for a vba solution to this.
Thanks in advance