Hello, I am wondering if there is any way to have it so if there is any data in column B-F, it will keep an extra row between the values from Column A.

This would make it so that my I could always have a blank row between data about different jobs.

So if A5 has a job number, and B4-F4 has data in it, A row would be inserted above Row A5, making the cell that was in A5, now in A6.

However if B4-F4 is blank, it is left in A5 and not pushed down to A6.

It wouldn't matter what cell its the fourth row, just as soon as it does, a blank row is created.

Sorry if this is confusing at all, but I had no idea how to word all this.