I have many excel file that I need to open and copy one number, 12 names and 12 dates. Then paste this text into a second wookbook. I have a lot of files and hope their is a way to automatically open each file and auto populate to second workbook, close file and open the next.
Sorry my first post, hope I'm giving enough info.
Any help would be greatly appreciated