+ Reply to Thread
Results 1 to 2 of 2

compare tables data

  1. #1
    Registered User
    Join Date
    06-17-2013
    Location
    Tunis
    MS-Off Ver
    Excel 2007
    Posts
    1

    compare tables data

    hello ,

    thank you alot for help that you provide, could you please help me in this subject:

    2 tables with diffrent size

    colomn1: contains files_name (first files_name begin at cell A2)
    row1: contains code_error_name(first code_error_name at cell B1)
    files_name and code_error_name may change position or be deleted between the two sheets so we need to make a search in colomn and rows to comprae data in the 2 tables .

    so I guess that the macro need to this , but I can’t do it in VBA
    search files_name from colomnA.sheet2 in ColomnA.sheet1
    if found
    search code_error_name from Row1.sheet2 in Row1.sheet1
    if found
    recuperate the coordinate of (files_name, code_error_name) from the two sheets than

    compare value in cell (files_name, code_error_name) in sheet2 with value cell (files_name, code_error_name) in sheet1 —> than highlight with diffrent color if not equal
    do this operation for all the table

    you find attached the 2 tablescomp_tab.xlsx

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,938

    Re: compare tables data

    Hi and welcome to the forum

    Im not sure exactly what sort of answer you are looking for, but this will search sheet2 for each item in sheet1, and return what it finds there. If the item on sheet1 does not exist on sheet2, it returns "not found" - you can change that to anything you want.

    =IFERROR(INDEX(sheet2!$A$1:$BA$588,MATCH(sheet1!$A2,sheet2!$A$1:$A$588,0),MATCH(sheet1!B$1,sheet2!$A$1:$BA$1,0)),"not found")
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

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