+ Reply to Thread
Results 1 to 2 of 2

Extract and Merge Data based on Column Headers

  1. #1
    Registered User
    Join Date
    02-20-2013
    Location
    Philippines
    MS-Off Ver
    O365
    Posts
    49

    Extract and Merge Data based on Column Headers

    Hi Guys!

    I need help on extracting data from different workbooks but will only extract the data based on the column headers. Then will merge all of the extracted data into one file.


    For example:

    File 1:
    Header 1 | Header 2 | Header 3 | Header 4

    File 2:
    Header 1 | Header 2 | Header 3 | Header 4
    In this example I want to merge
    "Header 2" from File 1 and "Header 3" from File 2
    (There will be more headers to extract/merge so can it be flexible on how many I can set up to extract?)

    --Location of column headers might differ on each file but all of the headers can be found in row 1.

    Is this possible?

    Thank you in advance!
    Last edited by Krix; 04-25-2017 at 12:20 PM.

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 2016 (Windows)
    Posts
    5,295

    Re: Extract and Merge Data based on Column Headers

    Why not Header 1 and Header 4 as well?

    Will all the data be on one worksheet, or do you need to look through all worksheets?

    Do you need to label the source of the data ? Anyway, code like this should get you started....

    Please Login or Register  to view this content.
    Bernie Deitrick
    Excel MVP 2000-2010

+ 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. Replies: 6
    Last Post: 12-13-2016, 03:06 PM
  2. Help required with Macro to Copy Data based on Column Headers - please!
    By Andycostin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-02-2014, 05:45 PM
  3. [SOLVED] Move Data From One Column to Another based on column headers and Row Text
    By DerbysGal in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 02-10-2014, 07:21 AM
  4. Replies: 3
    Last Post: 04-29-2013, 05:19 AM
  5. Replies: 2
    Last Post: 03-16-2009, 12:26 PM
  6. How do I: Extract column headers based on lowest number in sequence
    By WolfJack in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-21-2006, 04:30 PM
  7. Replies: 0
    Last Post: 04-21-2006, 03:40 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