VBA, macro, Excel - To compare and change according to two columns

[martintoth]

Hi guys,

I am struggling with creating macro that could compare and highlight changed cells in SAMPLE file.

I have MASTER file with first two columns that have to be used together as "Primary Key". I would like to CONCATENATE 1st and 2nd column and then somehow vlookup it and highlight changes made in SAMPLE file.

The biggest problem I see is that I can't add additional columns.

Any ideas how to finish this tricky exercise?
PS: How can I upload both files?

 

[martintoth]

Thank you Worf. You seems like good guy.

Cheers and have fun with Excel tools
Martin