Help With Current Macro Adding Copy Over

Hello,

Below is my Macro which currently takes two sheets and compares column "A in both, and if equal data is in both sheets column "A" it highlights in green. I need to take it one step further. Sheet1 being the master, and each sheet having three columns (A,B,C). I need to take data in Sheet1, column "C" to be copied to Sheet2, column "C" for only those cells that are highlighted in green (have same data in column "A" cells).

Current Highlight Macro

Please Login or Register  to view this content.

Thanks JR

Please Login or Register  to view this content.

the on error ... line was added to prevent the macro crashing if there is no match! NO MATCH => x will remain 0

Please Login or Register  to view this content.

Hello,

That seems to work perfect,

Thank you JR

you're are welcome just mark as SOLVED please.