I'm on call here in the US as well. So I don't have a promise that I will be off.

Ok I looked at the code and the only thing that I see as a possible problem and its something I could probably work around is that if for some reason if the column "E" results on the "missed devices" page is selected as "fail" the code will remain and not be removed. Everything else works. I'm pretty sure I can just simply add that to the statement using an "OR" statement. Great work though and once again thanks.

Do you have any idea how to limit what cells are displayed on printed / converted to .PDF? I'm trying to get this information to print to .PDF file but the way I have it right now it wants to print every column including column "K" and I have #s from 1-20000. When I convert to PDF it attempts to keep all those numbers and then it becomes a 1000 plus pages long with just numbers. Is there a way to allow the formula to use a hidden column? or get VBA to use information that is in a hidden column?