+ Reply to Thread
Results 1 to 3 of 3

Compare two worksheets in the same workbook and highlight the difference on the second

  1. #1
    Registered User
    Join Date
    04-12-2013
    Location
    london, England
    MS-Off Ver
    Excel 2010
    Posts
    2

    Compare two worksheets in the same workbook and highlight the difference on the second

    Hi;

    I have been requested by my manager to compare two worksheets within the same workbook - 'blended wage cost' and 'sheet1' (workbook attached).
    I would like some Excel professionals to help me to write some vba code to compare the column A - row 3 onwards (blended wage cost worksheet) with column A row 1 onwards (sheet 1 worksheet) and then highlight the rows yellow in 'sheet1' that aren't present in the 'blended wage cost' worksheet. I'm struggling to get this done so I would be very grateful for any help on this.

    Thank you
    C
    Attached Files Attached Files
    Last edited by chilun; 04-12-2013 at 05:30 PM.

  2. #2
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,445

    Re: Compare two worksheets in the same workbook and highlight the difference on the second

    Chilun,
    You have highlighted some cells in sheet1, but these are found on the other sheet. Try the attached
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    04-12-2013
    Location
    london, England
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Compare two worksheets in the same workbook and highlight the difference on the second

    Thank you very much sir.
    I'll have a look at the code and try to extend on this.

    Chilun

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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