I'm not sure if I'm not being clear enough in my request. Source workbook Sheet 1 Column c contains a list of names and I'm looking to copy these over to the Active Workbook, Sheet 1 Column C. If the name already exists in the Target workbook then don't copy, as Active workbook Sheet 1.column C needs to be a unique list of names.

My original thinking was to simply copy the full column over and then create a Unique list afterwards, but then I thought why not simply copy the name over if it didn't already exist. Am I wrong on both accounts as the best method?