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.