ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Populating Excel Web Query across workbook (https://www.excelbanter.com/excel-discussion-misc-queries/52231-populating-excel-web-query-across-workbook.html)

claytorm

Populating Excel Web Query across workbook
 

Hi,

I have a workbook with around 350 sheets. I have an Web Query which I
wish to populate in cell A2 of all of those sheets? The web query is
exactly the same for each sheet, just picking up a different input from
cell A1 in each sheet. How can I duplicate the web queries
automatically?

Thanks,

Bertie.


--
claytorm
------------------------------------------------------------------------
claytorm's Profile: http://www.excelforum.com/member.php...o&userid=11610
View this thread: http://www.excelforum.com/showthread...hreadid=479279



All times are GMT +1. The time now is 11:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com