I have a over a hundred workbooks in "D:\MyReports", each with the same format: (a) column A is a list of all publication dates, (b) column B is a list of all unique reference numbers, (c) sheet name is "source". I need to copy all the unique column B values and their corresponding column A values to a master workbook (sheet name "master") located in another folder: "D:\Master". The hitch is that there are cases where the reference numbers (listed in column B) are sometimes repeated in another workbook, so that a duplicate is created in the master workbook. How do I copy only the unique reference numbers in column B (and their corresponding publication dates - column A) to a master workbook without repetition?
Column A Column B
12/1/2016 1234345
10/3/2016 1345566
10/3/2016 1344559
10/1/2016 5391231
10/2/2016 4856066