Merge Workbooks

[vibhas]

I would like to merge 2 columns from workkbook A to workbook B. Bot
workbooks have a common code column. When I tried using Compare an
merge option from Tools, it was greyed out. I am using Excel 2002 an
windows XP

Thanks,
Vibh

 

[Frank Kabel]

Hi
how do you want to merge them?. e.g. column a stores the same type of
info but column B on each workbook different information?
You may have a look at the VLOOKUP function and use the common code
column as identifier. e.g.
=VLOOKUP(A1,'[book2.xls]sheet1'!$A$1:$B$1000,2,0)