Put same web query in same cell in each sheet

  • Thread starter Thread starter claytorm
  • Start date Start date
C

claytorm

Hi,

I have a workbook with multiple sheets, each containing stock data fo
a different company. I have a general web query, the only changeabl
parameter which forms part of the web address used in the query is th
three letter company identifier in a1 of each sheet. I want to put th
same web query in cell a2 of each sheet. I have the web query saved a
an iqy file. Is it possible to do this programmatically?

Thanks very much,
Bertie
 
Hello Bertie,

Could you tell me a little more about the data? Do you need to append
or insert the data in A1 to the query in A2? Could you post and example
of what you want to do?
It would help me better understand your needs.

Thanks,
Leith Ross
 
Back
Top