I have a folder that can contain multiple .xls files with different names but the exact same cell layout and sheet name. I need a macro to copy 3 of the fields from all files in that folder and paste them to the first open row in a different workbook.
Bookmarks