Help With Sheet Compare Marco I Trying To Use

Hello,

Thanks for all the help in the past. I have the below macro and what I need it to perform is the following. I have two work sheets Sheet1, Sheet2, and Sheet1 being the master. Column A is the data for comparison. I need the macro to read Sheet1 and compare to Sheet2. Whatever numbers are in Sheet1 that do not show up in Sheet2, I would like to be printed out to Sheet3. The below macro seems to highlight the whole column A in Sheet1?

Example:
Sheet1
A B
1001 Front Brakes
1002 Rear Brakes
1003 Fuel Line

Sheet2
A B
1001 Front Brakes
1002 Rear Brakes

Sheet3
1003 Fuel Line


Thanks for any help.

JR

Please Login or Register  to view this content.

Hello royUK,

Thank you for the reply. Yes, correct, but I could never get it to work. Sheet3 is never created?

Thanks JR