Compare Macro

Hello,
I need a little help with the below macro. I have a workbook with two worksheets. Worksheet 1 is the master. I need to compare worksheet 1 & 2, and whatever items (rows) that worksheet 1 has that worksheet 2 does not, I need to output to sheet 3. Column "A" is what I need to base the comparing. This column carries the model number. For some reason when I try to execute the below macro, (Alt F8), I get nothing in the macro popup? Any help would be greatly appreciated.

Thanks JR

Please Login or Register  to view this content.

Hello gaspower,

The Macro List Dialog ALT+F8 only displays Sub and Function Procedures that don't require arguments. You procedure does, and that is why is it isn't listed.

Sincerely,
Leith Ross

Thank you very much for the reply. How do I setup the arguments?

Thanks JR

Hello gaspower.

Set up another macro that calls the macro with arguments. "MyMacro" will show up in the list.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Hey Leith,

Thanks for the code. Now I get the pop up, and when I run the macro, the third sheet comes up, but blank. In sheet one, Column "A" original data, "10001", now says "10001<>10010? 10010 is in sheet 2. Not sure if this matters, but sheet1 and sheet2 have different row counts. I just need to compare column "A" and output. I noticed in the code, it is also comparing other columns?

Thanks JR