Hi!

I'm trying to figure a way to setup a web query (Using the WEB QUERY function), such that the web-address that the web query refers to can be an external field. If I can do this, I can enter the address at a pre-determined cell, and click refresh on the web query, and Excel will retrieve the information from the web-address specified in the cell.

I have tried to reference (i.e. =Sheet1!$A$!) in the address field of the web query but it does not work. I was wondering if you guys have any ideas on how to do this.

Thanks!