Solved: Find text in a column then move the row to left

[farrukh]

Hi All,

I need a piece of code that look in column b specific text if find then move the row to starting point A row.


Thanks
farrukh

[Bob Phillips]

Set cell = Columns(2).Find("my value")
Cells(cell.row, "A").Select

[raji2678]

As i understand, if a particular value is found in a cell, you want to move the entire row to the beginnning, right?

Have a for loop to loop through all the rows, If the value is found, cut and paste that row. Hope this helps.

[farrukh]

Yes exactly :)

[raji2678]

Can I assume that your problem is solved? If yes, kindly update the status.