ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Loop web query & pivot table...? (https://www.excelbanter.com/excel-programming/419902-loop-web-query-pivot-table.html)

J.W. Aldridge

Loop web query & pivot table...?
 
I have a web query that pulls data from a web page that updates
constantly.

Based on the data from the web query, I have a pivot table that
organizes the data found.

What is the best way (or rather how do I) to loop a web query to keep
it updated at all times?
Also how do I loop the pivot table refresh option to do the same?

Or am I asking too much of vba/excel?


All times are GMT +1. The time now is 01:27 PM.

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