2 Replies Latest reply on May 16, 2018 5:01 PM by Peter Fakan

    Multiplied sheets with the same source

    Bahar Hacivelioglu

      Hi,

       

      I have set a reporting template for the data of 4 different cities. Now, i would like to copy-paste it and just unhide the citites one by one while hiding the remaining at the same time. So I am to have the same reporting template for each 4 city separately. BUT, when I do that the source chart from the sheet also changes and it applies to all city reports since they share the same data sheet. How can I fix this?

       

      Many thanks for your answer in advance.