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

Match two excel spread sheet using Macro
 

Hi Lillian,

Need a bit of confirmation.

What rows do you want the data moved to? Just starting at top row and all
the moved rows one under the other in columns F, G and H or do they have to
be placed relative to the last matched row?

Also, does columns F, G and H have column headers or can column headers be
inserted?

When you say 'moved', do you mean that they have to be cut from the original
list or just copied?

Regards,

OssieMac

Match two excel spread sheet using Macro
 

OssieMac,

Thank you for help me out, acutally I want be like this

Sheet1 has 1000 records it has
SSN Name IPadress
123 linda 1.1.1.1
222 john 2.2.2.2

Sheet2 has 1200 records it has
SSN Name IPaddress
123 linda 1.1.1.1
222 john 2.2.2.2
333 bob 3.3.3.3

if A2 of sheet1 and sheet2 match then copy sheet1 of columA, columnB,
ColumnC to sheet2 of column F.G.H, so it would look like this on sheet2

SSN Name IPaddress ColumF ColumG ColumH
123 linda 1.1.1.1 123 linda 1.1.1.1
222 john 2.2.2.2 222 john 2.2.2.2
333 bob 3.3.3.3

that way I can see SSN 333 is not in the sheet1
I can see the match and not match both on same sheet 2.


"OssieMac" wrote:

Hi Lillian,

Need a bit of confirmation.

What rows do you want the data moved to? Just starting at top row and all
the moved rows one under the other in columns F, G and H or do they have to
be placed relative to the last matched row?

Also, does columns F, G and H have column headers or can column headers be
inserted?

When you say 'moved', do you mean that they have to be cut from the original
list or just copied?

Regards,

OssieMac