Relate entries on one list to those on another list

G'Day

I need to relate the entries in one list to those of the same in another list using a shared column name as the reference. Both lists are on the same sheet. A sample workbook with the code along with an example sheet of what I need to achieve is attached.

The code I have been playing with is from a working example which applied the code to columns running from right to left, but I need it to work from columns left to right - and this is where I have come unstuck. So I need some expert input please.

The issue:

In the “COMMON” section (columns J:L) of the TEMP sheet, every entry in the “Name” column (J) has a Country 1 (K) or a Country 2 (L) assigned to them. There will only be one or the other assigned.

In the “EVERYONE” section (columns A:H) of the same sheet, I have mostly the same names in the “Name” column (B), and duplicates thereof, but they do not have their country associated in either column D or F.

I need the code to locate the same names in this sections “Name” column (B), where they exist, then associate the same Country 1 (K) or Country 2 (L) entries as listed in the “Common” section, into the respective Country 1 (D) or Country 2 (F) columns in this ”Everyone” section. And not all names will have an associated Country to relate.

An example of what I want as the outcome is shown under on Example sheet.

try

Please Login or Register  to view this content.