+ Reply to Thread
Results 1 to 2 of 2

Merging 3 Worksheets

  1. #1
    Registered User
    Join Date
    07-17-2014
    Location
    San Francisco Caifornia
    MS-Off Ver
    Excel 2011 for Mac
    Posts
    1

    Merging 3 Worksheets

    I have 3 Worksheets in Excel I would like to merge into a new worksheet. Worksheet A, B, C. I have 133 rows of information on each sheet.
    I would like to merge them in a particular order. I would like to take Row1 of Worksheet A, then merge Row1 of Worksheet B, and then merge Row 1 of Worksheet C.
    So on the new Worksheet I have 3 rows of combined 3 worksheets.
    The would like to repeat this for all rows 2, 3, 4 etc. till will get to row 133 or end.
    Is this possible?

    Thanks in advance for thought and time!

  2. #2
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: Merging 3 Worksheets

    Try this code..
    in worksheet 4 (combined..)
    will Definitely help you...

    Please Login or Register  to view this content.
    Make a worksheet named "D" for the output..
    I am assuming your data starts from First Row..




    Don't forget to click *

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Merging two worksheets together.
    By StruglnPP in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-10-2012, 02:41 PM
  2. Merging two cells from different worksheets. Then merging both worksheets
    By ruth72 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-09-2012, 05:28 AM
  3. Merging Two Worksheets
    By patxlb in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-16-2009, 06:37 AM
  4. Merging Worksheets
    By andrewc in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-04-2009, 08:46 AM
  5. Merging worksheets
    By Ann in forum Excel General
    Replies: 1
    Last Post: 09-20-2005, 03:05 PM

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