Thank you all in advance, I have a worksheet that includes a dynamic web query. There are 3 inputs: a year, a location ID, and a statistic ID that are all part of their own data validation range. Currently, every time I change one of those inputs the web query updates successfully. What I'd like to do is run a macro that updates the 3 inputs to all possible values and after each change copy and paste the new web query results to a separate sheet.
The year input cell is E2, from data validation range A2:A12
The location ID cell is C9, from data validation range B14:B63
The statistic ID cell is C8, from data validation range B65:B633
The range to copy and paste to a new sheet is G:P and can be pasted in new sheet at A1.
Thank you!
Bookmarks