Vba that moves cells with text, (up and to left, insert row/ insert copied cell)

So I have a formula which is testing some key stuff (unimportant right now) if true then the cells get text, if not then blank. I copy and paste values so it is just blank or text. What I need is if the cells contain text then cut and paste the data above the cells to their immediate left. essentially inserting a new row and moving cells below down. I've included a sample excel of what I need it to do, if anyone can help it would be much appreciated. Thank You! I'm hoping the excel attached, but if it didn't please let me know cause I'm not seeing it even though it says it did.

Hi Mumps1,

Awesome the code is working perfectly, am the new learner of VBA can you please explain the above said code how it's working particularly why we are using here for the "Resize". Please explain indeed.

Regards
Raju

A little less movement by loop backwards.

Please Login or Register  to view this content.