aligahk06
04-25-2010, 01:54 AM
Dear All,
Attached file is for ref.
As per text in column v i want a macro or code that if text "DISMANTLE" is encountered then delete the row.
else do nothing.
The column V contains the Text " Dismantle" and otherwise.
Note:- In filtering mode deleting the rows consisting dismantle is tedious and risky if the data is two huge.
So I'm looking alternative and safe option.
Please assist?
Rgds,
Aligahk06
Attached file is for ref.
As per text in column v i want a macro or code that if text "DISMANTLE" is encountered then delete the row.
else do nothing.
The column V contains the Text " Dismantle" and otherwise.
Note:- In filtering mode deleting the rows consisting dismantle is tedious and risky if the data is two huge.
So I'm looking alternative and safe option.
Please assist?
Rgds,
Aligahk06