+ Reply to Thread
Results 1 to 9 of 9

VBA Code compare two spread sheets and highlight difference errors out on no match

  1. 01-29-2016, 01:51 AM #1
    KumarPK
    KumarPK is offline
    Registered User
    Join Date
    04-28-2015
    Location
    bangalore
    MS-Off Ver
    2013
    Posts
    56

    VBA Code compare two spread sheets and highlight difference errors out on no match

    Hi Experts,

    The below reference link shows extremely well. But I have one request, " At new sheet , Instead of showing the colors, can u pleases help to create new sheet which shows only changes , I want to see the entire row if that row.

    http://www.excelforum.com/excel-prog...-no-match.html

    Thanks
    Kumar PK
    Reply With QuoteRegister To Reply
  2. 01-29-2016, 01:54 AM #2
    abu0022
    abu0022 is offline
    Registered User
    Join Date
    03-14-2014
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: VBA Code compare two spread sheets and highlight difference errors out on no match

    Hello,

    I need a quick support from this group.

    I am in need to create a simple Excel Tool that should have the following:
    1) Questions with Answer Options
    2) Set of Questions would be under some categories which will have some weightages
    3) Each Answer Options will have some specific scores
    4) After completion of filling the questionnaire, the result should reflect in an overall score (may be out of 100)

    Can someone help me on this? I think a re-usable macro enabled sheet (in the similar line) should work with some editing/customization that I will do.

    Thank you in advance!

    Cheers.
    Reply With QuoteRegister To Reply
  3. 01-29-2016, 02:21 AM #3
    sourabhg98
    sourabhg98 is offline
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: VBA Code compare two spread sheets and highlight difference errors out on no match

    Press "Update" button on the Result sheet.

    Hope that helps!!
    Attached Files Attached Files
    Happy to Help

    How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html

    "I don't get things easily, so please be precise and elaborate"

    If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
    If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.

    Sourabh
    Reply With QuoteRegister To Reply
  4. 01-29-2016, 02:29 AM #4
    KumarPK
    KumarPK is offline
    Registered User
    Join Date
    04-28-2015
    Location
    bangalore
    MS-Off Ver
    2013
    Posts
    56

    Re: VBA Code compare two spread sheets and highlight difference errors out on no match

    Hi Sourabh,

    Its great, Can u pls show that if any New entries added in new sheet " Its shows " New Entry Added " at last column 'G' column (Result Sheet), if any cell value change it will shows Cell header Name and that cell color change to Yellow which is change .. is it possible...??

    Thanks
    Kumarpk
    Last edited by KumarPK; 01-29-2016 at 02:31 AM. Reason: Sheet name missing
    Reply With QuoteRegister To Reply
  5. 01-29-2016, 02:30 AM #5
    KumarPK
    KumarPK is offline
    Registered User
    Join Date
    04-28-2015
    Location
    bangalore
    MS-Off Ver
    2013
    Posts
    56

    Re: VBA Code compare two spread sheets and highlight difference errors out on no match

    Hi Sourabh,

    Its great, Can u pls show that if any New entries added in new sheet " Its shows " New Entry Added " at last column 'G' column ( Result sheet), if any cell value change it will shows Cell header Name and that cell color change to Yellow which is change .. is it possible...??

    Thanks
    Kumarpk
    Reply With QuoteRegister To Reply
  6. 01-29-2016, 03:01 AM #6
    FDibbins
    FDibbins is offline
    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,939

    Re: VBA Code compare two spread sheets and highlight difference errors out on no match

    abu0022 Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
    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 With QuoteRegister To Reply
  7. 01-29-2016, 03:02 AM #7
    sourabhg98
    sourabhg98 is offline
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: VBA Code compare two spread sheets and highlight difference errors out on no match

    Okay, Check attached.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  8. 01-29-2016, 03:10 AM #8
    KumarPK
    KumarPK is offline
    Registered User
    Join Date
    04-28-2015
    Location
    bangalore
    MS-Off Ver
    2013
    Posts
    56

    Re: VBA Code compare two spread sheets and highlight difference errors out on no match

    Thank you so much Sourabh... This is what I exactly looking for...Appreciate.

    Regards,
    Kumarpk
    Reply With QuoteRegister To Reply
  9. 01-29-2016, 10:44 AM #9
    sourabhg98
    sourabhg98 is offline
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: VBA Code compare two spread sheets and highlight difference errors out on no match

    Glad to know that helped!!

    You can click on "Add Reputation" below my post if that helped!!

    Have a Great Day!
    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. VBA Code compare two spread sheets and highlight difference errors out on no match
    By anfdrew in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-29-2016, 12:41 AM
  2. [SOLVED] VBA code to compare rows based on 4 column values and highlight is no match
    By Sirilias in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-16-2015, 02:22 PM
  3. vba code to compare coloumns on two worksheet and highlight difference
    By Sragel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-06-2015, 09:44 PM
  4. Compare Two Columns and Highlight the Difference
    By VickyVykciV in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-25-2014, 01:21 AM
  5. Macro that can compare sheets between 2 workbooks, highlight the difference
    By jeffboy29 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-19-2013, 11:31 AM
  6. Compare two worksheets in the same workbook and highlight the difference on the second
    By chilun in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-12-2013, 06:20 PM
  7. [SOLVED] How do you compare 2 list of numbers and highlight the difference
    By Jay Jones in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-20-2006, 12:50 PM

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