VBA to highlight differences between 2 tabs of data

[kenadams378]

In the attached workbook i have 2 tabs of data, current & previous.

I would like to write some code which compares to 2 sets of data and then highlights the difference between both tabs on the 'differences' tab.

Is this possible?

Regards

[TMS]

If current is different to prior, what would you show on the difference tab?

[Winon]

Hello kenadams378,

Do you really need VBA for this, if it can be done as demonstrated in the attached sample Workbook?

Regards.

[TMS]

Maybe this to start you off:

Please Login or Register  to view this content.

Regards, TMS

[kenadams378]

Thanks for your replies.

I just need to highlight the fect there are differences so some conditional formatting or true/false for each cell.

The one issue i do have is that the files i will be using will have differences in range, could this be incorporated?

[TMS]

This would just highlight differences without any specific values:

Please Login or Register  to view this content.

As for different size ranges, how does that work for you? I made the assumption that you simply needed to compare row by row, as did Winon. If that's not the case, it's a completely different problem.

Could there be rows added and deleted, as well as differences? For that, you'd need some sort of key field so that you could locate a "matching" row and then do the comparison.

If it's just a case of more rows on the current sheet, the range to be checked could be made to depend on the number of rows in the current worksheet. Of course, every cell would be marked as different.

One row of test data doesn't really reflect the complexity of the task.

Regards, TMS

[TMS]

Please Login or Register  to view this content.

Regards, TMS

[kenadams378]

Many thanks for this. Works a treat.

[TMS]

You're welcome.