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?