Thanks Devendra, I will send you some sample files for better understanding my requirements.Thanks again for your help.
Hi Sandeep,
I am sharing the code, If any group member can modify the code according to
you, would be helpful.
*** If we can assign few header names, of which data we want to extract
from the workbooks. It would be relevant. *
*Code *
Sub Merge_Files()
Dim objFSO As Object
Dim objF
Hi Devendra, Thanks for your reply. The problem is the headers are not same in all the files. But some column headers are same in all the workbooks.So, my requiremnt is a Macro which can search the column with th