Compare Two Collection to get differences, or compare two excels

Makus

New Member
Hello,

I need to Compare two collection, with the same columns name. Using loop and actions is to long for me.

Can anybody help me to write VBA Code or Excel Macro that will do it,

Input Source, Target.
Output Compared - when find differences set value "Source value: XY/ Target value: XYZ"

View attachment 2.jpg
 
Top