+ Reply to Thread
Results 1 to 4 of 4

Combining Column A in Multiple Worksheets into One Worksheet

  1. #1
    Forum Contributor
    Join Date
    01-29-2009
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    123

    Combining Column A in Multiple Worksheets into One Worksheet

    Hi

    I have tried searching but can't seem to find the right code for this. Thank you in advance for the help!

    • I want to combine just column A (there are other data in other columns not included in the attached sample xls) from multiple worksheets (sheet 1, sheet 2, and sheet 3) into one worksheet (Combined) in the order of the worksheets.
    • There are other "working" worksheets but I am not combining data from those. I can move them to the back if that helps and just combine the first few worksheets in that order.
    • And the "Combined" worksheet has to be constantly updated so I am thinking data on "Combined" need to be cleared first?
    • I also want to write the resulting "Combined" tab to a DAT file but I think I can find a code for that pretty quickly.


    Please help!

    Glenn
    Attached Files Attached Files
    Last edited by glennchung; 08-01-2014 at 02:25 PM.

  2. #2
    Forum Expert
    Join Date
    02-22-2013
    Location
    London, UK
    MS-Off Ver
    Office 365
    Posts
    1,218

    Re: Combining Column A in Multiple Worksheets into One Worksheet

    Hi,

    In the attached workbook, I included two ways to do it, on that triggers an update in the "Combined" sheet when a cell in Sheet1, Sheet2 or Sheet3 changes. This is done by putting a worksheet_event procedure in each of these worksheet modules:
    Please Login or Register  to view this content.
    Another way is to only update the "Combined" sheet when you activate it (put in the "Combined" sheet module):
    Please Login or Register  to view this content.
    Hope this helps!

    Cheers,
    berlan
    Attached Files Attached Files

  3. #3
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Combining Column A in Multiple Worksheets into One Worksheet

    Maybe:

    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    01-29-2009
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    123

    Re: Combining Column A in Multiple Worksheets into One Worksheet

    Thank you! They all work perfectly!

+ 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. Combining multiple worksheets into another worksheet
    By satchexcel in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-19-2014, 05:49 PM
  2. Replies: 2
    Last Post: 10-14-2012, 10:00 AM
  3. Combining multiple worksheets (tabs) into one tab/worksheet
    By COGICPENNY in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-25-2012, 01:05 AM
  4. combining specific column of certain worksheets, adding duplicates on combo worksheet
    By loves2laugh28 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-19-2010, 05:48 PM
  5. Searching Multiple Worksheets for Multiple Entries & Combining into one worksheet
    By Nick_Butler in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-27-2009, 10:48 AM

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