Getting Data from Multiple Web Pages -- Replicate changes made using Query Editor RRS feed

  • Question

  • 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 load the data into Excel.


    Is there a way I can replicate the changes made to the first sheet, onto the 2nd sheet, and so on ?


    There is an option to duplicate the in the Query editor, when I used the same, and duplicated one sheet, and changed the Data source, to be able to apply the same changes to the data from the 2nd source, it pulled the raw data, and the changes which I applied to the first sheet, were not replicated to the 2nd sheet.


    Any suggestions as to how I can achieve this ?


    End of the day, I want all the data from multiple web pages into one sheet, for which the append option works, but appends the data only from existing sheets, not from the web, so even that does not solve my issue.

    Tuesday, November 28, 2017 6:22 PM