Hello, I'm a complete newbie on Excel web queries, so please bear with me and keep the explanations as simple as possible.
I am using Excel 2002.
Here is what I am trying to accomplish:
1)Query this website:
http://na.finalfantasyxiv.com/lodest...=&blog_lang=en
and import the field with "15" as a number result in a cell on my spreadsheet. The rest of the field/info can be ignored, that's the only thing I need to query.
2)Query this:
http://na.finalfantasyxiv.com/lodest...=&blog_lang=en
and import the "13" in another cell, as before the rest of the info can be ignored (i'm trying to make the query as fast as possible as well since I will have a ton of them in the same spreadsheet)
Then I'll simply add those 2 in another cell on the spreadsheet. I have a lot more than 2 to query, but I can just insert more steps once I know how to do those 2 already.
Thanks to anyone who can help me do this.
PS: is there a limit to how many queries can be done in a single spreadsheet? Would there be an easier/faster way to add the same field on a large number of similar URLs and have it spit out to a .txt file or excel spreadsheet?
Bookmarks