Data comparison and extraction (VB Macro)

Dear All,

Can someone help me out in generating a macro for Data comparison and extraction (i.e., Compare and extraction of unmatched data and populate in new cell range)

I have clearly mentioned the requirements in Excel sheet enclosed (Please refer cells M4:M11)

Algorithm: for your kind reference.
Comparison check should be done for a generic data-set ie., it should run till the end of data 'n'
1. Comparison of each data of column C with all the data in column A
2. If it does not match, then populate the column C and the corresponding column D in a new column range (say G7:Hn)

I tried developing a VB routine based on the algorithm. The routine checks line by line for differences in Data1 and Data 2.
If a difference is found, routine is halted and cell selection box hightlights identified row.

But my requirement should follow the algorithm as explained before i.e extract the unmatched data and populate in a new column range.

Requesting you to please get me an Excel Macro for this.

Thanks in advance,

Kind regards,
reachspk123
(Note: Please do not use Excel cell reference formulae anywhere in the sheet. I request you to perform calculations using VB macros only.)