+ Reply to Thread
Results 1 to 3 of 3

Merge specific column data from multiple sheets in single column of new workbook.

  1. #1
    Registered User
    Join Date
    01-14-2016
    Location
    Mumbai
    MS-Off Ver
    MS office 2010
    Posts
    4

    Merge specific column data from multiple sheets in single column of new workbook.

    I am also looking for similar kind of macro to copy data from specific column of multiple sheets in single column of new workbook.
    For example I have 1 workbook with 12 worksheets. Each sheet is having 50 columns with large data. All these sheets are having one common column. I want to collect the data of that common column from each sheet in new workbook in single column. Data should be collected one below other without header.

    Is this kind of macro or vba code available?

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,937

    Re: Merge specific column data from multiple sheets in single column of new workbook.

    Just the column? What about the rest of the columns?
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Registered User
    Join Date
    01-14-2016
    Location
    Mumbai
    MS-Off Ver
    MS office 2010
    Posts
    4

    Re: Merge specific column data from multiple sheets in single column of new workbook.

    Yes one specific column. I don't need other columns data.

+ 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] Merge ranges from specific sheets by adding the sheet name as the first column
    By tabrizbalasi in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-24-2015, 01:38 PM
  2. [SOLVED] merge column D from all csv files in folder to single master workbook
    By up&down in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-04-2014, 06:31 PM
  3. Merge Multy Columns in Single column with data
    By sharma4845 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-22-2014, 05:00 AM
  4. Replies: 8
    Last Post: 10-02-2014, 05:23 PM
  5. Replies: 15
    Last Post: 01-24-2014, 06:32 PM
  6. Replies: 2
    Last Post: 07-21-2012, 08:36 AM
  7. merge data from multiple columns to single column
    By triggerthehorse in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-17-2005, 04:06 PM

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