Hi All,

I have excel file named as A.xls & B.xls

I get A.xls in morning and B.xls in Evening.( day 1 )

Once i get B.xls I need to compare this workbook with A.xls

ie., Col A has some codes in all workbooks that will repeated some
times.
So, If i know which one is repeated i will prioritize the work.

Here is an example,

A.xls
Col A
ABC45
IND45
AUD45
CZK47

B.xls
Col A
ABC47
IND45
AUD48
AUD46
CZK47
IN45

Compare B.xls with A.xls - there are some repeated codes.
i.e, IND45 & CZK47
i need the word "repeated" if it matches with A.xls in col B for B.xls

What I need ?
I will open B.xls and if i run the macro open dialog will come then I
will select
the A.xls and it need ask which sheet u need match, and then I will
select the sheet.
Then it will match.

File are not constant ...
Tomorrow I will receive C.xls then I need to compare with B.xls
if i received D.xls then I will compare with C.xls...... goes
on ,,,,,,

Thanks a lot in advance.