Posts by ltj22

    Hi everyone-I need some help on a catalog I am putting together in Excel. Here's the problem.


    I have a spreadsheet with products and their specifications. In the last column of this spreadsheet, there is either a part # or #N/A.


    What I would like to do is create a macro that will completely delete every line that has an #N/A in the last column.


    I cannot just sort the spreadsheet by the last column because it would change the order of the products.


    I'm sure there is a really simple answer to this that I am completely overlooking. Any ideas?