CuriousGeorg
03-18-2021, 07:08 AM
Hi there,
hope you can help.
I have a number of files that are saved in different folders each with their own password. Each one of these excel sheets then has a tab for each year from 2017,2018, 2019, 2020,2021.
What i need is VBA code to essentially open all these workbooks.. and copy the data on each sheet and paste it to the relevent tab on the master workbook.. so wb.England WS.2017 copied and pasted into wb.Master ws.2017.
Each of the worksheets needs to be appended to the bottom.
So if england finishes on Row 12, then scotland needs to begin pasting at row 13..
hope you can help.
I have a number of files that are saved in different folders each with their own password. Each one of these excel sheets then has a tab for each year from 2017,2018, 2019, 2020,2021.
What i need is VBA code to essentially open all these workbooks.. and copy the data on each sheet and paste it to the relevent tab on the master workbook.. so wb.England WS.2017 copied and pasted into wb.Master ws.2017.
Each of the worksheets needs to be appended to the bottom.
So if england finishes on Row 12, then scotland needs to begin pasting at row 13..