Results 1 to 2 of 2

File comapre and merge

Threaded View

  1. #1
    Registered User
    Join Date
    02-02-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    62

    File comapre and merge

    I have two excel files. I want to compare two files and merge.

    data in these files are exported from a DB.

    File1 has data like this in two columns

    primary-key | description
    --------------------------
    1| hello
    2| zero
    8| erwd



    File2 has data like this in two columns

    primary-key | description
    --------------------------
    1| hello
    2| zero
    3| mnp



    I want to make File3 merging these two files like this.

    primary-key | description
    --------------------------
    1| hello
    2| zero
    3| mnp
    8| erd



    How can I do this in excel ?
    Last edited by zerodegree; 07-30-2013 at 01:08 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. IP Subnet Comapre and write
    By dammler in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-23-2013, 04:00 PM
  2. Replies: 2
    Last Post: 01-22-2013, 11:37 AM
  3. Need to comapre 2 worksheets and need the difference in 3rd worksheet.
    By Hemanth Kumar J in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-06-2012, 01:06 PM
  4. Using a VLOOKUP to comapre data across 2 worksheets
    By kenadams378 in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 05-22-2012, 09:38 AM
  5. comapre 2 col.
    By Jimish in forum Excel Programming / VBA / Macros
    Replies: 28
    Last Post: 09-28-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