+ Reply to Thread
Results 1 to 2 of 2

Compare Cells from 2 WorkBooks and Highlight matches in current.

  1. #1
    Valued Forum Contributor
    Join Date
    02-04-2009
    Location
    Texas
    MS-Off Ver
    Excel 2016
    Posts
    665

    Compare Cells from 2 WorkBooks and Highlight matches in current.

    I have 2 workbooks stored on networked Drives.
    WorkBook A is the main file, WorkBook B is the reference file.
    WorkBook A has a list of part numbers in column B (some of which are repeated, and they are not in certain order)
    WorkBook B has a list of part numbers on constraint in column C (the number of rows will fluctuate)

    I would like the user to be able to open both WorkBooks and have the Macro highlight the matches on WorkBook A.
    Found this but it did not work:
    Please Login or Register  to view this content.
    Any help would be appreciated.

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Compare Cells from 2 WorkBooks and Highlight matches in current.

    It would be good if you attach a sample workbook so we can understand the data.

    Also, the matches should be highlighted in just 1 column or the entire row should be highlighted?
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ 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