Delete whole row if a cell from sheet1 equals from a cell from sheet 2

example

Master list is sheet1, column A3
now macro would look at column A2 from sheet 2
if it matches, then it will delete same cell row from sheet2


sheet1
---

A1 A2 A3 A4
-- --- -- ---
AA CC BB DD
QQ EE WW RR
AA DD SS FF
ZZ CC XX VV
11 33 22 44

sheet2
---

A1 A2 A3 A4
-- --- -- ---
AA BB CC DD
QQ WW EE RR
00 99 88 77
ZZ XX CC VV
55 55 66 44

result
(sheet2)

A1 A2 A3 A4
-- --- -- ---


00 99 88 77

55 55 66 44

is there anyone who could help me with this?

Try this one

Please Login or Register  to view this content.