I can't be too specific without an example worksheet.
In general... my approach would be to create a seperate tab, call it "Lookup" for this example, and have a list of all excluded items in that tab. Let's say that it's in A1:A100 of that sheet.
Then, I would smack a dummy column on the end of your table of imported data, and fill the first row, and then autofill down:
(This assumes the code is in A1 of whatever column you are importing in).
This will look and see if the value in A1 matches any of the values in the list, and return the position. But because we set the match type to "0", if it doesn't find a match, it will return an error code. We wrap the MATCH with the ISERROR function to create a boolean to feed to the IF.
So all you do is Filter the dummy column for "Use" and remove the "Don't Use."
Then, whenever you add or remove an item for filter, you add/remove from the lookup list. Then, the criteria for the IF changes, but the filter itself operating on the list stays exactly the same.
Bookmarks