Hi Guys,

I have sheets called "Matt, Dion, Tamara, John" etc.

And one sheet called "Master"

Now What I would like to do is if column A in sheets "Matt, Dion, Tamara, John" matches a value in cell B1 in "Master" &
if column G in sheets "Matt, Dion, Tamara, John" matches a value in cell B2 in "Master" then delete that entire row within sheets "Matt, Dion, Tamara, John".

It must meet both criteria . If both criteria are not met then the row should not be deleted and should only be deleted if it matches both If statements.



Any help is greatly appreciated.