Results 1 to 16 of 16

Compare 2 sheets, match data in 1 column, update row in sheet 2 & add new rows not matched

Threaded View

Synchronicity Compare 2 sheets, match data... 05-10-2012, 02:16 AM
watersev Re: Compare 2 sheets, match... 05-10-2012, 11:10 AM
Synchronicity Re: Compare 2 sheets, match... 05-14-2012, 05:02 PM
Synchronicity Re: Compare 2 sheets, match... 05-10-2012, 11:22 AM
watersev Re: Compare 2 sheets, match... 05-15-2012, 10:23 AM
Synchronicity Re: Compare 2 sheets, match... 05-15-2012, 12:07 PM
Synchronicity Re: Compare 2 sheets, match... 05-15-2012, 09:23 PM
watersev Re: Compare 2 sheets, match... 05-16-2012, 05:54 AM
Synchronicity Re: Compare 2 sheets, match... 05-16-2012, 11:19 AM
Synchronicity Re: Compare 2 sheets, match... 05-16-2012, 01:59 PM
watersev Re: Compare 2 sheets, match... 05-16-2012, 03:59 PM
Synchronicity Re: Compare 2 sheets, match... 05-18-2012, 11:07 AM
Synchronicity Re: Compare 2 sheets, match... 05-29-2012, 01:16 PM
mohan.mreddy2 Re: Compare 2 sheets, match... 06-13-2013, 06:57 AM
raja63 Re: Compare 2 sheets, match... 11-11-2013, 11:50 AM
arlu1201 Re: Compare 2 sheets, match... 11-11-2013, 01:21 PM
  1. #1
    Registered User
    Join Date
    05-09-2012
    Location
    Long Beach
    MS-Off Ver
    Excel 2010
    Posts
    9

    Compare 2 sheets, match data in 1 column, update row in sheet 2 & add new rows not matched

    Hi Everyone,

    I have a problem that I am not sure how to solve. I have searched the forums and found some code that is close, but doesn't quite do what I need it to. Hopefully someone can help me out.

    Summary: I need to copy and overwrite rows of data from one sheet to another sheet but with a little logic. I want to look at the data in a specific column on both sheets. If there is a match, then I want the data from that specific row in the sheet 1 to overwrite the matching row in the sheet 2. If there isn't a match in the sheet2, I want the row from sheet 1 to be added to the bottom of sheet2. Lastly, I want to keep all entries in sheet 2 that do not have a match.

    Detail: I have attached a workbook with sample data. The data in sheet 1 (GWI022712) comes from a system that exports a CSV file. This sheet is updated every week and contains the latest data from a 6 month window. Column D has a unique ticket number that I want to try to match in sheet 2. Sheet 2 (GWI MASTER DATA) contains the same columns as sheet 1 and needs to be updated with the latest data from sheet 1. What I want to do is compare column D on both sheets and if a match is found, update the entire row on sheet 2 with the data from the matching row on sheet 1. New entries on sheet 1 that do not have a corresponding match on sheet 2 should be added to the bottom of sheet 2. Finally, older entries in sheet 2 that do not have a match (over 6 months old) should not be deleted. Obviously, I don't want to match the column header.

    I would really appreciate any help offered. Thanks!

    ~CS

    EDIT: Forgot one thing, I would like to reserve the last few columns on Sheet 2 for formulas so I don't want them to be deleted when the macro runs. Or I would need a way to quickly replicate them to the bottom of the sheet if they are overwritten.
    Attached Files Attached Files
    Last edited by Synchronicity; 05-10-2012 at 11:12 AM.

Thread Information

Users Browsing this Thread

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

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