Import Multiple Pages from Web with One Query in Excel

In this video, we import multiple pages of data from a website with one Excel query using Power Query.

We create a table of URL's that can automatically update on a sheet, import data from the web and then turn it into a function with some M code.

We then create a custom column to use this function and feed it the URLs from the table to import as many pages as we want.

Find more great free tutorials at;
http://www.computergaga.com

*** Online Excel Courses ***

The Ultimate Excel Course – Learn Everything ► https://bit.ly/2Ag5AKH
Excel VBA for Beginners ► http://bit.ly/2JvnnRv
Advanced Excel Tricks ► https://bit.ly/2UlTfvB
Excel Formulas Made Easy ► http://bit.ly/2t3netw
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2viGg3J

Connect with us!

LinkedIn ► https://www.linkedin.com/company/18737946/
Facebook ► http://www.facebook.com/computergaga
Twitter ► http://www.twitter.com/computergaga1