+ Reply to Thread
Results 1 to 2 of 2

match Sheet1's column header to sheet2's column header and copy range over if matches

  1. #1
    Registered User
    Join Date
    09-15-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    56

    match Sheet1's column header to sheet2's column header and copy range over if matches

    Information to copy are from sheet2.

    It works like an index match but I want to try an alternative method.

    Please Login or Register  to view this content.
    Something like that but does not work as both headers1 and headers2 never seem to match.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,604

    Re: match Sheet1's column header to sheet2's column header and copy range over if matches

    Try matching the first several characters on the left of each header.
    Ben Van Johnson

+ 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: 07-25-2013, 02:58 PM
  2. Replies: 0
    Last Post: 01-16-2013, 07:46 PM
  3. [SOLVED] Simple formula to match column A, sheet1, with column A, sheet2, return text answer
    By Connie5761 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 11-14-2012, 02:56 PM
  4. .Find header and column in another workbook and copy the cell that matches both
    By Ariadust in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-06-2012, 12:15 AM
  5. Match Header...Copy Column
    By mjack003 in forum Excel General
    Replies: 6
    Last Post: 09-23-2005, 09:05 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