(1) I have a NBA stats-reference website. [login to view URL]
(2) I need to gather boxscore stats of each game. There are 1230 games in a NBA regular season, and almost 100-110 games in playoffs.
(3) Sports Network's scoreboard will be used as the main data source. [login to view URL];misc=10&page=nba/scores/live/[login to view URL]
(4) Here is sample box score where I want data to be pulled from from. [login to view URL];page=nba/scores/final/[login to view URL]
(5). Your task is to write a macro or software for the data to the specified format in excel. Check out this file: the macro should visit each game's box score and pick up the data to single sheet. There may be 14 games maximum in a day and a minimum of 2 games.