Insert a row

[tsturtz]

I would like to insert a row above another, only when there is data in column A and there is no blank row above it.

Any help would be great.

Thanks, Tony

[beaunydal]

You might be able to use a couple of helper columns and sorts to achieve the row inserts.
See the 5 steps in the attachment.
Final result is on Sheet3.

Beau Nydal