$20 USD - Delete rows based off of multiple criteria - VBA.

  • Hi All,


    Looking to delete rows in a spreadsheet based off of values that are present in three different columns.
    In layman's terms, here is what I'm trying to accomplish.


    If Column B does not have a value of "BONY01" and values in Column O = 0 and Column P = 0, then delete that row.


    In other words, I only want to view records of BONY01 that have a value other than 0 in either Column O or P or both. Everything else should be deleted.


    Spreadsheet may have several thousand rows.


    I've attached a spreadsheet with an original tab and a desired results tab for clarification as well.


    Sent 10% to Oz..... Transaction ID 4N645467MA471815X Thanks in advance for the assist.

  • Do you actually want to delete the rows, or just "hide" them...?


    Edit: Sorry KjBox, go ahead. I'm too slow... as usual :(

    Check out our new reputation system. Click on the Like button under the post!
    _______________________________________________

    [SIZE=8px]There are 10 types of people in the world. Those that understand Binary and those that dont.


    Why are Halloween and Christmas the same? Because Oct 31 = Dec 25...


    The BEST Lookup function of all time


    Dynamic Named Ranges are your bestest friend[/SIZE]
    _______________________________________________

  • Payment received, many thanks


    Here is the code, change sheet name for your actual workbook sheet name where indicated

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.