Hi all,

Appreciate if anyone could help out on this issue. I have a range of datas
on sheet 1 and another range of data on sheet 2. Sample as below :

In sheet 1,

Company Name Sales Fig.
D Limited 4000
A Limited 1000
E Limited 5000
B Limited 2000
C Limited 3000

In sheet 2,

Company Name Sales Fig.
E Limited 5000
D Limited 4000
C Limited 3000


I want to match data in sheet 1 to my data in sheet 2 becos my priorty is
the data in my sheet 2.
As such, "A Limited" and "B Limited" must be flag as unmatch entry in sheet
1 and be deleted immediately. On top of these, the data in my sheet 1 must be
sorted the same sequence as sheet 2. That is, in sheet 1 shown as

Company Name Sales Fig.
E Limited 5000
D Limited 4000
C Limited 3000

That is same data as my sheet 2 at last. I cant use custom list in excel
becos my range of data will be as many as few hundred rows


Thanks