Macro to scan through sheets and delete data that matches value in cells

[christian2016]

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.

[Neil_]

Please Login or Register  to view this content.

[christian2016]

Thanks works a treat.

Is there a way to enter a message box saying how many rows were deleted ? Also if no rows were deleted.

Thanks

[bakerman2]

Try this.

Please Login or Register  to view this content.

[christian2016]

Saying no rows were found although the row is being deleted.

I think its not counting correctly.

[bakerman2]

Just made up example file and works perfectly fine for me.

[christian2016]

Yep seems to be working.

Unsure what I did wrong.

Thanks again