Quicker External Data From Website into Excel single worksheet Help

[SimonLee]

Hello everyone! I am trying to grab some stats from this website quicker. http://sports.yahoo.com/nfl/stats/by...ld_category=QB


I want to grab all the stats for position(QB, WR, RB, TE, DEF, K, S, DE, DT, CB, P, of week 1-17(TimeFrame) of the 2008-2011 season(Year) all at once and put it onto one single worksheet of excel.

can somebody help me out?? Thanks!

[npamcpp]

You may want to take a look at the forum rules and then change your thread title before expecting an answer.

[p24leclerc]

Here is a draft of a quick download of NFL data into multi sheets workbook.
It is formated as it comes from the web site you specified. No manipulation was done with data. I just added the season in column A so you have this information to work with.
Look at the macro and you should be able to understand how it works and how to modify it to suit your needs.
If not, call for help again.
Regards

[SimonLee]

hi. how do i grab alll the stats for all the positions from year 2009 season to 2011 season and the timeframe is from week1-17. (17 weeks * 3 seasons data) = 51 times. i don't want the time-frame to be set to All. i wish i know how to modify it.

[p24leclerc]

Here is a file the might help you download data from your web site.

[SimonLee]

Hi Pierre. It's not working can you make it get 2011-2013 data? I was searching for old file similar to this one and looks like yahoo did copy to site maybe to prevent maybe needs to modify it again?

http://www.excelforum.com/excel-prog...heet-help.html

Book1.xls was working and now it don't work for link above. it just displays the year along with the number of weeks for 2008-2010 with week 1 - 17.