I need help desperately - please

I have a tab in a spreadsheet (sheet 2) with about 200 rows (one column) of
text. I have another tab (sheet 1) in the same spreadsheet with about 16,000
rows of text.

I need a formula or macro that will do the following:-
If the text in R1C1 of sheet 2 exists and matches text in sheet 1, then
delete or blank out that text in sheet 1. Then move on to R2C1 of sheet 2 and
do the same thing, then R3C1 and so on.

I am thinking a looping macro, but I don't quite know enough about how to
write a macro. If it can be achieved with nesting formulas that's also OK. So
far I have used "MATCH" and "ADDRESS" formulas to give me the exact reference
in sheet 1 for the text from sheet 2 but I am stuck with how to use that
reference in a macro or formula that will delete that exact reference in
sheet 1.

Cheers
--
Thank you in advance for your assistance.
James