This can certainly be done but it's not entirely clear what you need. It sounds like that you want the data copied to a different sheet and then have a procedure go through and check several conditions. If any of those conditions are true you want it to delete a row. Could you post a sample workbook with the desired result and I would be happy to write something up for you.