Deleting rows on one sheet based on a condition in another sheet in the same file

Hello,

I have a column of data on one sheet in a file and a column of data on another sheet in the same file. I was wondering how you could delete a row on one sheet if the other sheet contained a row that had the identical value.

As an example, this will delete row 1 in sheet1 if the value in A1 on sheet1 exists in column A in sheet2:

Please Login or Register  to view this content.

as a loop for all of sheet1 column A:

Please Login or Register  to view this content.

It most certainly does adyteo, thank you very much for that. Will add to your reputation.

Terrific ragulduy, your method just proves that there is more than one way to do the same thing. Thank you very much for your assistance and your prompt response, will add to your reputation for you.