+ Reply to Thread
Results 1 to 2 of 2

Compare Data in 2 Columns in 2 sheet When there is a match transfer data from 2nd Column

  1. #1
    Registered User
    Join Date
    12-08-2014
    Location
    South Dakota
    MS-Off Ver
    MS Office 365
    Posts
    49

    Compare Data in 2 Columns in 2 sheet When there is a match transfer data from 2nd Column

    I have order information in two different spreadsheets ("Sale" & "Ship To") Both have a field/Column "Customer #" I want to compare the customer numbers between the two sheets and when there is a match transfer the data from Sheet 2 "ShipTo" to blank columns in the Sheet 1 "Sale."

    I've attached an example workbook I put together.

    Thanks so much in advance!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,905

    Re: Compare Data in 2 Columns in 2 sheet When there is a match transfer data from 2nd Colu

    Paste into E2 and drag across/down:

    Please Login or Register  to view this content.
    Spread the love, add to the Rep

    "None of us are as smart as all of us."

+ 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] Match Data from Another Sheet and Transfer Values
    By basketball2524 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-20-2013, 11:49 PM
  2. [SOLVED] Compare 2 sheets, match data in 1 column, update row in sheet 2 & add new rows not matched
    By Synchronicity in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 11-11-2013, 01:21 PM
  3. [SOLVED] Compare two columns and copy and paste data from a third column when a match is found
    By GatorsBucs in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-28-2013, 06:54 PM
  4. Replies: 0
    Last Post: 06-14-2013, 01:36 PM
  5. Replies: 5
    Last Post: 09-24-2009, 03:46 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