Macro to delete all rows that do not have a specific value in column I

  • HI all--


    I need a macro that will delete all rows that do not have a value of "808068" in column I and I need this to start at row 14. Please help! I've seen similar answers but they delete the first 13 rows and I need them.


    Thanks so much in advance!

  • Re: Macro to delete all rows that do not have a specific value in column I


  • Re: Macro to delete all rows that do not have a specific value in column I


    Hi mzilberl,


    Welcome to OzGrid!!


    Apart from AlanSidman's nifty solution here's another way which as it doesn't loop is very fast:



    Regards,


    Robert

Participate now!

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