+ Reply to Thread
Results 1 to 2 of 2

Joining multi file into one file

  1. #1
    Registered User
    Join Date
    06-26-2013
    Location
    Việt Nam
    MS-Off Ver
    Excel 2010
    Posts
    2

    Joining multi file into one file

    I want to join multi file (or sheet) into one file with same format.
    Ex:
    Sheet 1 (file 1):
    King 1 --King 2
    AAA ----- 1
    BBB ----- 2
    CCC ----- 3
    Sheet 2 (file 2)
    King 1 - King 2
    DDD ----- 1
    EEE ----- 2
    FFF ----- 3

    Result
    King 1 ---King 2
    AAA ----- 1
    BBB ----- 2
    CCC ----- 3
    DDD ----- 1
    EEE ----- 2
    FFF ----- 3

    Please help me with formula.
    Thanks all.

  2. #2
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: Joining multi file into one file

    try this macro:
    Please Login or Register  to view this content.
    it will copy content of every sheets but the sheet "Sheet3".
    Sheet3 is the plave where all contents will be placed
    Pierre Leclerc
    _______________________________________________________

    If you like the help you got,
    Click on the STAR "Add reputation" icon at the bottom.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1