Import .xls file in .xlsm file using macro and vlookup the sheets in new sheets

Can any one has idea how to do it?

Hi,
You've mentioned some columns for lookups, but what exactly you need to lookup? What is the base data? What is "FDW GL"?
Please state your problem more clear, like: I need to take all values from sheet "FDW GL" column "LOC_GL_ACCOUNT_CODE" and lookup values from this column in sheets "BW GL" and "ECC GL". If match is found, then ... if not ...

Hi Kasan,

The base file is "ECC GL.XLS", column G/L acct.
The column "GL_ACCOUNT" from BW GL .XLS & column "LOC_GL_ACCOUNT_CODE" from FDW.xlsx needs to be vlookup with the column "G/L acct" from "ECC GL.XLS".

I have wriiten code to import these 3 files from a particular path, after importing i need to vlookup as mentioned whihc is not happeinng as of now, getting some error. The vlookup should happen in a sheet name called "Reconcile"

Try this one. Run the same Sub Reconcile().
Specially corrected one value in each sheet (BW GL and FDW GL) to test, you will see #N/A in first two rows.
Dont know what is COA on Reconcile sheet, what do you expect to get there?

Hi kasan,

Thanks for your help, its working fine as of now.
I will test and let you know if i need anything more.
Thanks again