+ Reply to Thread
Results 1 to 4 of 4

Excel 2007 : How to merge multiple sheets in multiple workbooks to a sinlge sheet

  1. #1
    Registered User
    Join Date
    03-02-2010
    Location
    home
    MS-Off Ver
    Excel 2007
    Posts
    2

    Exclamation How to merge multiple sheets in multiple workbooks to a sinlge sheet

    Hi Community,

    This is my first post!

    My goal is to merge multiple sheets in multiple workbooks to create a master sheet in a different workbook.

    Example:
    WorkBook1Sheet1
    A 1 2 3 4
    B 5 6 7 8

    WorkBook1Sheet2
    C 9 10 11 12
    D 13 14 15 16

    WorkBook2Sheet1
    E 17 18 19 20
    F 21 22 23 24

    WorkBook2Sheet2
    G 25 26 27 28
    H 29 30 31 32

    WorkBook3Master (desired results)
    A B 1 2 3 4 5 6 7 8
    C D 9 10 11 12 13 14 15 16
    E F 17 18 19 20 21 22 23 24
    G H 25 26 27 28 29 30 31 32

    I am currently merging the data manually, which is very tedious.

    Can this be done without a Macro or VBA? If it does, can you suggest where to look for help to create a Macro or write the VBA code or can this be done with an existing tool in MS Excel 2007?

    If require any additional information, please post, I will elaborate.

    Thank you in advance.

    Cheers

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: How to merge multiple sheets in multiple workbooks to a sinlge sheet

    Hi Homie
    will it always be two rows per worksheet?
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

  3. #3
    Registered User
    Join Date
    03-02-2010
    Location
    home
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: How to merge multiple sheets in multiple workbooks to a sinlge sheet

    Hi Pike, Thank you for your post.

    The worksheets may contain more than two rows.

  4. #4
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: How to merge multiple sheets in multiple workbooks to a sinlge sheet

    first bit fill in the paths and file name in the code below
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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