View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lillian Lian Lillian Lian is offline
external usenet poster
 
Posts: 26
Default 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