Querying tables from a website from a column of hyperlinks

[holmdeal]

I am attempting to find a way to query a baseball player's minor league statistics from a website with tables. Basically, I want excel to go to a hyperlink, copy the tables, and paste them into a new worksheet named after the player. Some of these players do not have data yet, though it should be added eventually.

For example, in the attached spreadsheet, I would like to get the data from the hyperlink in cell F14, which corresponds to "Danny Poma" (cell E14) Then, I would like to copy the table "Minors Batting" from Baseball Reference into a new sheet called "Danny Poma." Then, when re-running the macro in the future, I want these tables to update as the player's season continues.

I feel like a macro would be the best way to do this, though my VBA skills are lackluster to say the least. Any help would be greatly appreciated. Thanks.

[JBeaucaire]

This macro should do it... along with a hidden "Template" sheet I added to your workbook that serves as a design target for creating new sheets. The macro uses the Names in column E and the links in column F:

Please Login or Register  to view this content.

[holmdeal]

Thank you so much. This is exactly what I was looking for.

[JBeaucaire]

If that takes care of your need, please select Thread Tools from menu above and set this topic to SOLVED.