How to merge Excel files from one floder to one excel file?????????

[uttam.mothe]

Hi All,

I have excel files in one folder, all files have same header

I want all those files merge into one new excel file in one sheet, header should copy only once in the sheet



Thank you....

[HaHoBe]

Hi, uttam.mothe,

sorry that neither the forum search nor google has brought up the relevant links for you. Maybe have a look at WBs to 1 Sheet where you maybe have to adapt the code to just import the header once (adapt the range to import, use a Boolean to decide to copy or skip the first row) or Merge data from all workbooks in a folder.

Ciao,
Holger