Building different tabs for the different markets within the same Google Sheet doc
I am trying to build new tabs within the same Google Sheet doc for different markets. I have already made one and was thinking that I can just duplicate the tab that I wanted to copy. Then I copied all the queries for the 1st tab and pasted below in the SupermetricsQueries Tab, followed by changing the Sheet Name, Range Address, Account/views and Filters so that those are the ones for the 2nd tab. I left the rest empty.
Unfortunately, when I refreshed all the queries, the Sheet Name and Range Address got mixed up. Even those that were initially meant for my 1st tab got changed to 2nd tab.