Match two excel spread sheet using Macro
I have one excel sheet, on sheet1 and sheet2 as following...
sheet1 has 1200 records
ColumnA ColumnB ColumnC
123 xxxx YYY
222 xxxx xxxxx
sheet2 has 1000 records
ColumnA ColumnB ColumnC
123 xxxx YYY
234 xxxx XXXXX
222 xxx xxxxx
if ColumnA of sheet1 and sheet2 are not match, like my example has 234, then
I would this row moved to sheet1 of column F, G, H.
Thanks.
Lillian
|