Pull data from an internet source about college football and place it in charts

[dnorris707]

the following program is supposed to pull data from an internet source about college football and place it in charts. the first program makes the charts then the next one organizes them. the way it works is by putting the first game of every season in, then going back and putting in the second and so on. I have gotten it to where it will input text in the correct areas, but im not sure how to make sure its putting the right data.

Please Login or Register  to view this content.

[Ed_Collins]

Hi dnorris,

I can see you're really having some trouble with your project.

This macro might make it easier for you. At the click of a button, the workbook below will go to that jhowell website, and download all of the data for you.

You can then begin formatting it as you wish.

Each team will be listed on its own tab.

To avoid having a single workbook with almost 300 tabs in it, you will probably want to run it a few times, creating new workbooks with 20-30 tabs each, or something like that.

college football data for dnorris.xlsm

Enjoy.