You are reading a single comment by @Light_EDDed and its replies.
Click here to read the full conversation.
-
What's the website? I have done this before with limited success using the "From Web" function. But I'm a luddite so it's usually trial and error for me depending on the site and whether I can pinpoint the right field or not.
-
Power query may well be the best thing for this (which you'll get with Data > From Web).
I find google sheets is often better for this with the ImportHTML command although if you really need it in Excel you then need to link to that.
stevo_com
aggi
@Light_EDDed
Another excel question. Slightly more complicated.
Is there a way to link a cell to a website with a changing percentage on it, so the cell updates when the websites percentage changes? If that’s too vague I can go into more detail?