I am testing a new system and have already imported all 30 NBA teams along with scores into excel via web query however the imported data doesnt give me boxscores, it just gives me final scores. I already have the url's to the box scores but need to find out how to actually link the box scores to the corresponding cells. For example if I click on a date in cell A1, I want another worksheet to pop up with the boxscore of that particular matchup. I am scraping the data from www.basketball-reference.com.
I have zero excel knowledge but google is a mans best friend..lol. If i wanted to get the boxscore from the Atlanta Hawks game on October 28,2009 I would get it from here
http://www.basketball-reference.com/boxscores/200910280ATL.html
I would like to go to that page and grab the boxscore table data then import it into a worksheet in excel and have it popup whenever dates in the worksheet are clicked.
The parameters are pretty basic and relatively straight forward for scraping the boxscores but I'm stuck on linking the dates in column 1 to the box scores
Here is what my spreadsheet looks like so far
I have zero excel knowledge but google is a mans best friend..lol. If i wanted to get the boxscore from the Atlanta Hawks game on October 28,2009 I would get it from here
http://www.basketball-reference.com/boxscores/200910280ATL.html
I would like to go to that page and grab the boxscore table data then import it into a worksheet in excel and have it popup whenever dates in the worksheet are clicked.
The parameters are pretty basic and relatively straight forward for scraping the boxscores but I'm stuck on linking the dates in column 1 to the box scores
Here is what my spreadsheet looks like so far
