VBA - Merge multiple files to one sheet


New Member
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 :)

Some videos you may like

This Week's Hot Topics