Thread: Macro using VLOOKUP between multiple workbooks

Hi all,

I am kinda of new to Macros. What I am trying to do is, lookup cell B1 from workbook "TESTsp.xls' in workbook 'test.xlsx' and check column 'D' for INHERENT', if both these conditions are met then copy columns E, I, K, Q, and S into a workbook 'TESTsp.xls' at columns H, J, L, N, and O, respectively.

Thank you for all your help.

Mark

the attached workbooks

Help anyone?