When you create a new query, our add-on creates a named range for it. The named range is called "zsupermetrics_" + the query ID. When you refresh a query, the add-checks whether the named range for the query ID exists, and if so, places the new data there. If that named range doesn't exist (or there's no query ID for the query), it will look at the "Range address" column in the SupermetricsQueries sheet. If there's no range specified in that column, it will look at the "Range address (static)" column in SupermetricsQueries.


To copy move queries within the same sheet:

  1. Delete the query Id in column A
  2. Copy the range address from column E and paste it temporarily to somewhere else in the sheet with a right click, "paste special" --> "paste values only"
  3. Modify the values to change the position of the query
  4. Copy the modified range address and paste it as values only in to range address in column E (replacing the old one)
  5. Change the sheet name in column D if needed
  6. Refresh the query


To copy the query to another file:

  1. Copy the whole query line in to the new file's SupermetricsQueries sheet
  2. Delete the query Id in column A
  3. Copy the range address from column E and paste it temporarily to somewhere else in the sheet with a right click, "paste special" --> "paste values only"
  4. Modify the values to change the position of the query
  5. Copy the modified range address and paste it as values only in to range address in column E (replacing the old one)
  6. Change the sheet name in column D if needed
  7. Refresh the query