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?
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?