Excel equivalent to Google Sheets' "importdata" function?

[greesonbrad]

Hello,


I want to pull some financial data from a website. Google Sheets has a fantastic function for grabbing data from tables. In my example, I want to pull the balance sheet for a specific company. Here is a link to the Google Sheets' example


Is there an Excel equivalent? I tried getting external data, but it does not allow for a variable web address, so I would be limited to only one stock...not desirable.


Is there a macro for doing such table grabbing?


Thanks for any help!