So I've got excel setup to perfom web queries on a number of different websites. No problem there. However, what I'd like to do is to have a webquery (say in WorkSheet_3) pull the website to query off of WorkSheet_2 cell D1.
So the result would be:
WorkSheet_2 performs a webquery on a site that contains links to other pages, I'd have excel spit out the web address in column D
WorkSheet_3 through WorkSheet_15 (for example), would perform a web query based off of the corresponding website in WorkSheet_2
Example:
WorkSheet_2 performs Web Query on Covers.com matchups for NFL (covers.com/sports/nfl/football-matchups.aspx) and in cell D1 the result would be the 1st link found on that page for trends (covers.com/pageloader/pageLoader.aspx?page=/data/nfl/matchups/g1_trends_1.html)
Now Worksheet_3 would perform a webquery using WorkSheet_2 Cell D1 as the website.
Hope that makes sense. I've researched Dynamic Web Query and cannot seem to find any information on getting Excel to do what I want. Any help would be appeciated. Thanks.