Hi Guys,

I need a VBA coding to find a specific text in cells.
1. If text is found in that cell. Move that row up 1.
2. If text is not found, then do nothing.

Says my worksheet "Test" has about 100 rows (1:100) of data from Column A to H.
Now IF the word "Gone" appear in any cells of Column C, then move the cells from B to H (Same row with text "Gone") up by 1 row. Finally, remove the entire row that has just been moved.

Thanks Guys,