Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Comparing two Excel Sheets Automatically

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    New York
    Posts
    53
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,

    I have 2 Excel Sheets with the same columns and formats that I would like to compare and end up with two new sheets (1) containing only the unique records derived from both sheets and (2) another sheet with the duplicate records, identifying the cells that caused the duplication. I've tried the Advanced Filter functon but this just created the unique records. I do not know which were the duplicate records and which columns caused the duplication. Is there a way to do this with a macro ?

    Thansk in advance

    frank

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Ahmedabad Gujarat
    Posts
    303
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You can do this by downloading a small utility from my website..

    http://www.pexcel.com/download.htm

    name of the file is comparerange to compare the two range.

    and to find duplicate you can download the file

    findduplicatevba


    it is the last file.

    ni****h desai
    http://www.pexcel.com

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •