Hey Guys! My questions is quite complex I hope someone can help me with it...
I want to find information from Excel Sheet 1 and remove only those rows
from Excel Sheet 2. The repeated information has identical columns. For
Example:

|Column A| B| C| D|

Sheet 1:
| 1 | John Johnson | 1234 Fake Street Avenue | California |
| 3 | Jane Doe | 824 Main Street | Nevada |

Sheet 2:
| 1 | John Johnson | No address | None |
| 2 | Brad Gensen | No address | None |
| 3 | Jane Doe | No Address available |N/A|

and then find the identical info from sheet 1 and remove the cell row from
sheet 2, leaving me with :

Sheet 2:
| 2 | Brad Gensen | No address | None |

THANKS for your help guys! really appreciate it!

~johnny b