Hi all,
I need an application that will look at the names column B of workbook 1 and compare them with the names in column B of workbook 2. If there are any entries in workbook 1 that are NOT in workbook 2, they will be highlighted in yellow in workbook 1. Is this possible?
Thank you.
Yes its possible. Please attach a sample workbook so we can understand what kind of data you are looking at.
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]
Here are some small sample workbooks. In this example, it should look at the ID number column in workbook 1 and highlight any that aren't found in the ID number column in workbook 2. In this case, row 4 should be highlighted. Thank you very much for the help.
hello and welcome to the forum, this code might help you.Assumed that only workbook 1 has unique entries. and other entries are arranged in one to one order in both workbooks except unique entries
Please Login or Register to view this content.
Last edited by shaukat; 12-17-2011 at 09:07 AM. Reason: expalanation
Hi this script will overcome the problem explained before.Now numbers in any order will be dealt with:
Please Login or Register to view this content.
Last edited by shaukat; 12-17-2011 at 09:32 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks