How to Copy Queries for Excel

You can copy queries to re-use them in the same file or even different files. Below are two different methods you can use to do this properly.

• Method #1: Duplicate Query Action
• Method #2: Manual Copy

Method #1: Duplicate Query Action

This method only works within the same worksheet. If you want to copy across files, see Method #2 below.

1. In your Excel worksheet, open the sidebar (Data->Show Supermetrics).
2. Place your cursor on the data for the query you wish to copy.
3. This should cause the sidebar to load the query data.
4. Click the Duplicate button, which will load the query details in the sidebar as a new query.

   

5. Modify the query, if required.
6. Place the cursor into an empty cell that will be the starting point for the copy. Make sure it's an empty cell with enough room around it that will not overwrite other data in the sheet.
7. Click Get Data to create the new query and pull the data.

   

Method #2 : Manual Copy

This method works both for making copies in the same worksheet or for copying queries into a new worksheet.

1. In your Excel worksheet, open the SupermetricsQueries tab. This is the saved configuration of all the queries in the file.
2. Find the row that is the query you want to make a copy of.
3. Highlight the full row and copy it.

   

4. Paste the row into the next available row in the configuration in the destination worksheet (so would be row 20 in the example images).
5. Delete value in the following cells for the just copied query: Query ID, Sheet name, Range address.

   

6. Scroll to the far right and find the second Range address (static) column. Update the value in the copied row to the place in the file you want the query to exist in, both the sheet name and the range.

   

7. If you have any other adjustments to make to the query, you can do that as well in the appropriate columns. You can also wait until it's created in the next step and then can modify it in the sidebar as normal.
8. Then in the sidebar, open the menu in the top left and select Refresh all to have the copied query's data added in the range address location given. It should also have a new unique query ID given.

   

   

9. Check that the data for the copied row refreshed into the correct placement in the sheet (if not, you can adjust the range address again and refresh it to move it).