Macro to change cell for each value in range, copy and paste dynamic results

That's a hell of a lot of combinations and I suspect it could be perceived as a DoS attack on the web site.

https://en.m.wikipedia.org/wiki/Deni...service_attack


Regards, TMS

I appreciate the heads up. I guess I could look to do them in much smaller increments, considering one of the inputs is year. I could keep the year static and do it over a longer period of time. Any ideas on the code, even if the request is smaller? Additionally, this is one of the early lines in that copy and pasted Wikipedia reference: A distributed denial-of-service (DDoS) is where the attack source is more than one–and often thousands–of unique IP addresses. It would be from one IP address, and wouldn't be any different than if I did each request one by one, which I have access to.

Well, it's just a triple nested loop: for i=2 to 12, for j=14 to 63, for k=65 to 633. But my issue/concern would be the 50 locations by 570+ statistics; that's 28,500+ iterations. If you did include the year, that would be 313,500+ iterations. In the inner loop, you move the cell values to the query cells and fire the update.

I suspect timing might be an issue, waiting for the query to update before copying and pasting the results.

In theory, it's doable, but it would be somewhat resource hungry and probably slow