Hi
I have a folder called Top Ten and every week a new workbook will be added to the folder called Top ten Wk1 and so on until week 52
I need a workbook called Year to date that will look into each workbook and copy columns A, B, C & D into one list and if a duplicate name is found to add Columns B, C, & D to that name.
Please find attached a sample workbook
Sheet1 shows what the 52 workbooks will look like and sheet 2 shows what the Year to Date workbook will look like and the results I need.
Hope you can help
Dave
Bookmarks