Hello,

I am writing to seek help, in writing a macro which can filter the an two column dataset (columns E and F) by matching duplicate names from column B and E.

An clearer example of the problem is represented in the attachment below:

https://www.box.com/s/90443sgddohl2y3z7li0

The file shows sheet1 with input data and desired output shown in the columns H and I, as an example.

Please Note: The actual data is in sheet 4 and the desired output would be updating the dataset in columns E and F to match names in column B.

Any help or guidance would be very much appreciated.

Thank you.