I am writing to request macro (VBA function), which allows to me to see different data value (from column K and L from duplicate rows of data.

For example €“ please input sheet from the attachment.

Process €“ the macro, should look through lines of data which have duplicate name values (from column A), identify which rows from column K and L are different from the duplicate values. The macro should highlight the difference in yellow, as final output.

Expected output €“ please see output sheet from the attachment.

Sample attachment - https://app.box.com/s/3i1bpvbov5vr8h4v36hqy684elcwk8xw


Any help would be very much appreciated. Many thanks.