Thanks Devendra, I will send you some sample files for better understanding my requirements.Thanks again for your help.
the column with that
> particular header name (common accross All the workbooks and paste it.
>
> Regards,
>
> Sandeep K Chhajer.
>
> Sent from my BlackBerry 10 smartphone.
> *From: *Devendra Sahay
> *Sent: *Wednesday 27 January 2016 10:59
> *To: *excel-macros@googlegro
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
l Macros
> *Reply To: *excel-macros@googlegroups.com
> *Subject: *$$Excel-Macros$$ Merge multiple Workbook
>
> Hi Excel guru,
>
> I have found macros for merging multiple workbook (kept in a single
> folder) into a single worksheet.
>
> But my requirement is a step ahead.
Hi,Any way to solve this problem.
Hi Excel guru,
I have found macros for merging multiple workbook (kept in a single folder)
into a single worksheet.
But my requirement is a step ahead...can that macro to be changed to copy
only specified column from every wrokbook (Sheet1). Like it will search in
all the workbooks (sheet1 row no
