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!
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!