Delete matching entries on excel

[ghrek]

Hi

First of all I posted something similar on this website and now regret as mr excel more helpful.. macro is showing as data missing but it is not missing and cant get it to amend.

I have a spread sheet and what im trying to do is get it to look in sheet 3 and compare against a sheet called TAB and if any matching entries across columns A-D in a particular row then I need them deleted from sheet 3.

The entries will be spread all over the sheets in rows a-d so need it to go through the whole sheet.

Any ideas?

 

[MARK858]

Can you test what jindon has posted on the other forum first so we know where we stand please.

 

[ghrek]

Sorted. Many thanks though