Forum Discussion

Keith011's avatar
Keith011
Icon for Helper III rankHelper III
3 years ago
Solved

Is it possible to load specific query to a specific empty tab in excel?

Hi there,

 

Is it possible to load specific query to a specific (existing) empty tab in excel?

 

This is my excel workbook. "raw_data" is just me pasting raw data into that tab. "Table 1" is where power query exisit. "Sheet1" is an empty sheet i created manually in excel

 

this is my power query in excel. I want to tell power query to specifically load this "Testing" query into the "Sheet1" tab. can i do so?

 

  • if it's your first time loading, just select "Create&Load to" to put the query where you want.

    if the query has been loaded before, just right click it in the right Queries pane, select "Load To"

1 Reply

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Icon for Community Champion rankCommunity Champion

    if it's your first time loading, just select "Create&Load to" to put the query where you want.

    if the query has been loaded before, just right click it in the right Queries pane, select "Load To"