Hello,
i have three worksheets: "List 1", "List 2" and "New ist".I want to merge the first two sheets into third.
List 1:
List 2:
The first four columns A,B,C and D of "New List" are all the same as in "List 1". Now the column E of " New List" contains members of column D from "List 2" but without duplicates.
Now the members of column D "List 1" should be seached in Column A "List 2" and if they match (member Column D "List 1" = member Column A "List 2") then the corresponding member of column D "List 2" should be put in column E of "New List".
Jindon had once kindly sent here a code which works very well but it allows duplicates in column E which now i want to be changed. No duplicates should be allowed in Column E "New List".
New List:
Here is the code which is supposed to be changed, so that column E has no duplicates:
Thanks for each help in advance!
Here is excel file containing the macro:
Bookmarks