Hi friends:

Could someone devise a macro to do the following operation? There are 2 workbooks, WorkbookA and WorkbookB. WorkbookA is a fixed reference workbook having 125 rows and columns A: P. WorkbookB can be any workbook having 50 to 300 rows and columns A :D. I want to compare string values in Column B of WorkbookA with string values in A column of WorkbookB and if they match, transfer corresponding data from WorkbookA Columns H, I, L, and P to WorkbookB columns E, F, G, and H respectively. I work in Excel 2003.

Both workbooks have a title row and data from second row onwards.