VBA - Merge multiple files to one sheet

[BarneyLTD]

Hi everyone, thanks for the help on previous questions and the continued support.

I have written some VBA to export some invoice to load in to sage but now need to combine the days exports in to one sheet to upload.

Each export contains a sheet with a header row (A1:AI1) then a list of lines to invoice. Ideally what I need to do is

• place all files in a folder that are to be combined
• open a template file that contains the headers
• open each of files and combine the data from sheet 1, row 2 in to the template, on the one sheet.

can anyone help with this?

Cheers

 

[James006]

Hi,

With many different workbooks ... you should take a look at Power Query

https://www.myexcelonline.com/blog/c...g-power-query/

Hope this will help

 

[BarneyLTD]

Works perfect James Thanks

 

[James006]

You are welcome