Find text then cut and paste in same worksheet

Hi, sorry but I am a newbie at this so I hope someone can help me!

I am trying to create an Excel macro that will do the following:

1. Search a column for cells that contain specific text.
2. Cut the entire row.
3. Paste the cut row into row 2 of worksheet.
4. Repeat steps 1 to 3 until all reocrds containing the specific text are at the top of my sheet.

I think I should be using a Do...Loop statement but for the life of me I can't work out exactly what to do.

Any guidance would be greatly appreciated.



  • Hi, I no longer need any assistance with this. I have found a way of using Autofilter to get what I need.

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


In this Discussion