find matching cells on two different sheets

[aem172]

Hi,

Here is the situation:

I have two sheets in a workbook. On sheet 1 in columns A,B,C I have information. On sheet 2 in columns A,B,C I also have information. In column C on both sheets are numbers similar to SSN. I need a macro that will look at the values in column C on sheet 1 and then go to sheet 2 and find the exact number also in column C. Then, once the number is found, I need the macro to delete the entire row the number is in. Any help would be greatly appreciated. I am very new to macros and have no idea where to start. Thanks!

 

[stanleydgromjr]

aem172,

Welcome to the board.

Just to clarify your request. Is the following sentence correct?

If a number in Sheet2 column C, matches a number in Sheet1 column C, then delete the row in Sheet2.

Have a great day.
Stan