Macro To Compare Worksheets And List Differences With Exceptions

Hi

Can someone please help me out with this, I have attached a sample to try and explain what I mean.

As you will see I have 2 work sheets within the workbook, Info & Table

What I am trying to do is have a macro that will look at Columns A & B in the Table work sheet against Columns C & D in the Info work sheet and then list the differences in column E in the Info worksheet

The problem is they won’t always run in the same order so the best way round it is to look at column A in the Table worksheet then match that number against column C in the Info worksheet then check the B column in Table against the D column in Info if they are different list the correct one the E column in Info.

The correct one will always be the one that is listed in the Table worksheet.

I have over 30,000 listings in the workbook so this can usually take a lot of time; any help would be greatly appreciated.

I have done the first 2 in the sample to show you what I mean these are listed in the Info sheet,
A9 & A19