Delete a row if a specific value exist on another sheet

[I_malc]

Can anybody help me I new to VBA and I'm trying to copy data from one sheet to another, then delete any row that is blank in a column, and then delete any row that has a value that is equal to a cell on another sheet that is a named range “House1”?

[excelledsoftware]

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.