Macro For Web Query for multiple pages of information into on Excel Sheet

[brownfest99]

Hi all,

I am looking for a little macro help.

I am trying to import 10-20 pages of we information into a single excel sheet.

Baseball stats for fantasy. I love it and it keeps me busy during down time.

I am a beginner at code to say the least, but have a little experience.

Here is what i am trying to do.

Major League Leaderboards » 2016 » Batters » Custom Statistics | FanGraphs Baseball1_50

That is the link to the information I am trying to get, the highlighted RED part is the page number and number of entries in the table. Pages go from 1-9 but could also go a little higher.

I want to set up a macro that downloads all 9 (or more) of the pages into a single sheet in order.

I have been able to run a few different macros but cant seem to get the correct info. The table I am looking for is labeled as Table 12 according to the HTML code. (99.9%) sure of this.

Any and all help would be greatly appreciated.

 

[brownfest99]

Iterating over multiple pages of web data using Power Query – Matt Masson

this seems to be what I was looking for if, anyone else is having the same issues that I was having.

This is a great resource.

 

[ECB]

That might be what I'm looking for