Project overview
I am unable to find an example on google of what i want to do. I want to:- 1. Open a data workbook 2. Within the workbook merge the sheets 3. Copy the data into a master sheet 4. Close the data workbook 5. Open the next data sheet (there are 50 data sheets) 6. The final product will be the master workbook with 10,000 rows in a single sheet containing all of the data The final product will be a master sheet containing all of the data from 25 seperate data sheets. The sheet attached contains the macro i have setup. I want a loop added to this macro so that 50 data sheets are opended. I have attached 3 data sheets for reference. I want my existing macro updated to loop, so i assume its a 15 minute job for someone who knows vba in excel. Please read the existing macro in the .xlsm instead of asking 1000 questions.