Compare 2 columns and highlight the new value,

**fpolaco** · 05-07-2012, 11:58 AM

Hello,
This is my first post on the forum, so i want to Say Hello!
Nice Forum!
I need some help since i get lost searching for a solution.
I need to work with 2 xls files i will call them xls1 and xls2. Xls is a master list that has one column with unique names, and the xls has another column inside that can have the same values and new values. I need to highligth these new values. on the 2nd xls.
Can someone help me with this? :-S

Thanks in advance!

**arlu1201** · 05-07-2012, 12:40 PM

Welcome to the forum.

Sure, we can help you out. How about attaching 2 sample files - 1 each for both your .xls files?

To Attach a File:

1. Click on Go Advanced.
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

**fpolaco** · 05-07-2012, 01:27 PM

Hi,
I just attached 2 files as example, xls1 is my master, and xls2 is a report i have to run monthly, so then i need to compare with the master and on the xls2 highlight the new entries (the ones that are not present on xls1)

Thanks

**arlu1201** · 05-07-2012, 01:56 PM

Which columns in both the files need to be compared to highlight the new values?

**fpolaco** · 05-07-2012, 02:03 PM

column b from xls1 and column c on xls2, highlight the new values on the column c

**arlu1201** · 05-07-2012, 02:22 PM

Try this code. Copy this code to workbook xls2. It will copy the contents of xls1 to a temp worksheet. Then it will copy the contents of xls2 to the temp worksheet and compare both. The result will be provided in the temp worksheet.

Please Login or Register  to view this content.

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste

To run the Excel VBA code:
Choose View | Macros
Select a macro in the list, and click the Run button.