Import From Web Missing Data

[wrasser]

I am trying to import data from web to excel. I posted the link below to the website I am attempting to import from. The only part I need is the statistics. However, I cannot get it come thru by getting external data from web. Can someone please advise how I can get this to work.

The goal is to great an auto updating spreadsheet with multiple sheets so copy and paste is not feasible.

http://www.teamrankings.com/nfl/stat/points-per-game

This has also been posted here
http://www.mrexcel.com/forum/excel-q...ml#post3335653

[MarvinP]

Hi wrasser and welcome to the forum,

Excel will import HTML TABLES that are on a webpage. In Excel 2010 you click on the Data Tab and then the From Web icon. You then paste in your link above and see where the little yellow arrows are. Each of these yellow arrows points to a HTML table, or something it can grab. There is no yellow arrow around the data you want to import.
This means this web page isn't using a HTML table to display the data and you can't import it into Excel.