Combine several *.xls files into one

  • Re: Combine several *.xls files into one


    I want them in a same sheet.
    All files in a same folder.
    They're not named in set format, but columns ito the files have the same format and names.


    First I need to copy one file, after that from the last row + 1 the next file and e.t.c

  • Re: Combine several *.xls files into one


    This solution should get you started.


    Zip file contains
    1. Combine.xls - main import workbook
    3. Test files


    NB. See the SetUp worksheet.
    This assumes that there is a single common worksheet in all the files.
    You can rename the common sheet name to your situation
    You can change the start copying rows from number.


    Hope the syntax is ok

  • Re: Combine several *.xls files into one


    Thanks a lot Turbo. Works great!! Just have to remember to select all the xls files when in the "Open File" window then hit open.

  • Re: Combine several *.xls files into one


    Is there anyone who can help me? I also have several excel files with same columns which i want to combine into one file.
    However, the columns starts on a Row 5 instead of row 1 and there are blank rows in between.

    Would appreciate your help. Thanks!

  • Re: Combine several *.xls files into one


    Francis,

    Welcome to Ozgrid. Please do not post questions in old threads. Please start your own thread with a Search Friendly Key Word title. If necessary refer back to a previous thread with a link if you feel that will help your explanation or if it contains a partial solution that you have tested but does not quite match your circumstances.

    Always explain your problem with as much detail as possible. You are likely to receive a much faster solution this way.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!