+ Reply to Thread
Results 1 to 2 of 2

Comparison of 2 sheets from different workbooks and highlighting the differences

  1. #1
    Registered User
    Join Date
    03-14-2010
    Location
    istanbul
    MS-Off Ver
    Excel 2007
    Posts
    1

    Comparison of 2 sheets from different workbooks and highlighting the differences

    Hello all,

    I tried to google a solution for my problem but since I am new to macros and codes I couldn't manage to come up with a solution.

    I have data that I have to compare every week. I have a table containing all the data from columns A to V with no more than 100 rows. I need to check the data from previous week and highlight the increased numbers in red.

    The tables are on different workbooks but somehow I need the mark the differences of the current week's sheet in red.

    I hope that what I am writing is making sense.
    I'd appreciate all the help.

    Thanks

  2. #2
    Registered User
    Join Date
    10-31-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Comparison of 2 sheets from different workbooks and highlighting the differences

    Hello,

    I am also having same requirement and today while searching I came across a software called Florencesoft DiffEngineX which works well for the requirement mentioned.

    Nitin

+ 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