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?