Combine Data From Multiple Worksheets into a Single Worksheet in Excel

Want to combine data from multiple worksheets into a single worksheet?

While you can do that by using copy paste of VBA, it's an area where Power Query excels.

With Power Query, you can easily (and quickly) combine data from tables in multiple sheets into one single table.

The only pre-requisite is that the data should be in Excel tables or at least names ranges.

In this video, I will show you how to use the Excel.CurrentWorkbook function to get a list of all the tables, and then use Power Query to combine these with a few clicks.

You can read more about this method here (and can also download the example file) - https://trumpexcel.com/combine-multiple-worksheets/


Free Excel Course - https://trumpexcel.com/learn-excel/
Paid Online Training - https://trumpexcel.com/excel-training/
Best Excel Books: https://trumpexcel.com/best-excel-books/

⚙️ Gear I Recommend:
Camera - https://amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - https://amzn.to/2uzhVHd
Wireless Mic: https://amzn.to/3blQ8uk
Lighting - https://amzn.to/2uxOxRv

Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexcel?sub_confirmation=1

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial

Видео Combine Data From Multiple Worksheets into a Single Worksheet in Excel канала TrumpExcel