Hello,
I am new in this forum and would like to ask for a solution code in VBA which I cannot create by myself. I know some VBA coding but I cannot find a solution to this problem:
- List of names in a text file "names.txt" - each line is a name
- Excel table "names" in worksheet "sheet1", in column A are a list of names. Each row is a name
1) I want to check the column A for duplicates and if there are duplicates to eliminate them
2) I want to import the list of names from "names.txt" in the column A if there isn't already a row with the same name as in "names.txt"
My goal is to have a list of unique names in the teble "names" in column A
Thank you for your help - I really appreciate it!
Tony
Bookmarks