16 folder with team (teamA teamB etc) Each team has many members on the team. In each spreadsheet there is a cell that has the team memebers name. I would like to to make one set of 20 copies (represeting a two week period of time for dataes.) of the spreadsheet and link one cell to the team members last name in the master workbook from the first pay period. In VBA can I write code to grab data from a closed workbook in the same folder and put in the activfe cell in the open workboodk.
somehting like onopen get teh data from MAster.xls a24 and putin in second.xls and put in a24
somehting like onopen get teh data from MAster.xls a24 and putin in second.xls and put in a24