+ Reply to Thread
Results 1 to 2 of 2

How to compare and move data from one sheet to another

  1. 08-28-2014, 07:14 PM #1
    cgonzo1970
    cgonzo1970 is offline
    Registered User
    Join Date
    08-21-2014
    Location
    puerto rico
    MS-Off Ver
    2010
    Posts
    2

    How to compare and move data from one sheet to another

    I have this excel on which I want to compare two sheet for request number, and bring the new ID from sheet 2 to the blank space on sheet one..
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-28-2014, 07:45 PM #2
    dizzle
    dizzle is offline
    Registered User
    Join Date
    07-14-2010
    Location
    Seattle, WA
    MS-Off Ver
    PC 03/07/10 | Mac 08/11
    Posts
    43

    Re: How to compare and move data from one sheet to another

    A simple vlookup using Column B sheet 1 as the ID to search on Sheet 2. I used an IF statement to show any cells that do not exist.

    SAMPLE (fixed).xlsx
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. compare data and move it to new sheet
    By savio in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 07-28-2014, 09:02 PM
  2. [SOLVED] Compare 2 sheets and move unmatched to sheet 3
    By JAYRUES in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-12-2012, 07:07 AM
  3. Compare columns in worksheets and move to correct sheet.
    By CRIMEDOG in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-29-2011, 12:25 PM
  4. How to identify text (compare) in one sheet, then move it another
    By mag7417 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-14-2005, 10:54 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1