Delete Rows That Dont Have Certain Text

  • Hi


    I have a sheet with data only in column A


    I want to remove any rows that dont contain the word MAR.


    All the lines with MAR in start with:


    CN=GR GG COF MAR ****


    Would anyone be able to help me with a macro which would do this as i have over a 100 sheets. and maybe an explanation as i am totally new to this?


    thanks in advnace

  • Re: Delete Rows That Dont Have Certain Text


    Hi Cameo,


    Try this, code notated to help explain;


    Cheers,
    Ian

  • Re: Delete Rows That Dont Have Certain Text


    Quote from IanDunnett

    Hi Cameo,


    Try this, code notated to help explain;


    Cheers,
    Ian



    OMG


    Thanks a million, that worked a treat. im gonna go throiugh it and try to understand, but thanks again - colin

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!