Need to Highlight New Entries Between 2 Sheets in Same Workbook

**Whit804** · 10-26-2012, 11:40 AM

First, let me say I am relatively new to Excel and have no experience with VBA. But I am a quick learner and willing to try anything.

I download a report every couple of hours. This report changes each time and I need to compare the newest report against the last saved report and highlight the new entries on Sheet2.

Every time I download the report, I want to delete Sheet1, rename Sheet2 to Sheet1, and paste the newest report as Sheet2. (I can do that part manually) I need to compare Column F, named "Incident #" on both sheets and highlight any rows on Sheet2 that do not appear on Sheet1.

Is this possible?

15days Sheet 1.xlsx

**arlu1201** · 10-30-2012, 05:41 AM

Try this code

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

The macro will create a new sheet called Temp and do the comparisons. It will return to you the rows that are not present in 1 but present in 2. If the sheet Temp already exists, the macro will delete it and start afresh each time you run the macro.