Match cell content from another sheet & delete automatically

[Dr.Calculus]

I have two sheets with data. I want to match the cell contents in my no2 sheet to the respective in sheet no1, and then have those cell contents that have been matched in sheet no1 be deleted automatically. How can I do that, instead of comparing one by one and deleting them manually?

[Lupp]

Welcome to the forum!

To be able to try an answer I need more information.

Question1 in return (I'm not a native speaker of English): How should "... to the respective..." be interpreted here?
All Sheet1 cells of same content?
Same cell address in Sheet1?
Otherwise? How?

Quesion2 in return:
Shall only (constant) content be matched or also formula results?

Question3 in return:
Can you (approximately) describe the "size" of the problem? Solutions probably working for a few thousand cells may be too inefficient for much more.

(Depending on your answers additional questions in return may be necessary. You may better describe wat you eventually try to achieve.)

[Dr.Calculus]

So in sheet 1 i have 2 columns: the 1st contains specific numbers while the 2nd contains text. The sheet 1 contains more than 3000 entries.
In sheet 2 now again I have 2 columns: the 1st contains text and the 2nd specific numbers that can be found in the respective column in sheet 1. These are approx. 100 entries.

What I want to do is delete automatically the text that corresponds with the 100 specific numbers (of sheet 2) in sheet 1, without having to manually search-and-find each entry separately (while comparing with sheet 1).

[Villeroy]

=ISNUMBER(MATCH($A1;$Sheet2.$B$1:$B$100;0))
returns TRUE if this row's value in A ($A1) has an exact match in Sheet2.B1:B100. Expand the formula downwards, filter the list by TRUE values in this column, delete entire rows, remove filter.

A spreadsheet is not a database no matter how many users try to use it as a database.