Forum Discussion
Getting Data from Multiple Web Pages -- Replicate changes made using Query Editor
I am getting data from Multiple Web pages into multiple excel worksheets. Each Web page has the same format, and the same changes need to be made to each worksheet using the Query Editor before I loa...
Hi Gurpreet,
You may create the query for one web page, after that duplicate it from the menu (right click on the query) and use for another web page. Connection string to web page could be hardcoded or defined as parameter. Or you may create the function based on such query with URL as parameter.
And one more query on the top which appends all results and loads into the summary sheet.
"duplicate it from the menu (right click on the query) and use for another web page."
I cannot find any such option. I am using Excel 2016 on Office 365.