Wise Owl Answers - How do I copy data from multiple worksheets in other workbooks?

Check out our other answers here https://youtube.com/playlist?list=PLNIs-AWhQzcluqE43JKakRKslaYwCouJu

Download files here https://www.wiseowl.co.uk/vba-macros/videos/vba-files-folders/copy-multiple-sheets-and-workbooks/

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this link https://www.wiseowl.co.uk/donate?t=1​ to make a donation. Thanks for watching!

This video explains how to loop through the Excel files in a folder, opening each one in turn then looping through the collection of worksheets in the workbook and copying the data from each worksheet into a master list in another workbook.

Chapters
00:00 The Question
01:16 Finding an Excel File in a Folder
03:11 Looping Through Excel Files in a Folder
04:01 Opening and Closing Each Workbook
05:18 Looping Through Worksheets
06:28 Copying the Data Rows
09:22 Setting the Destination Range
12:06 Testing the System
12:43 Adding Improvements
15:09 Alternative to Copy and Paste

Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Power BI, DAX, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access and more

Видео Wise Owl Answers - How do I copy data from multiple worksheets in other workbooks? канала WiseOwlTutorials