Mimic one sheet to another

So we have a Sheet we use as of Master sheet but had to create a copy of the that Master as we used up the max number for summaries for that Master. Is there any way to make it so anything that is done on the Master will automatically also be done on the Copy? i.e new rows, value change, rows moved


  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    It is, but it is not very efficient. What type of data are you tracking in the Summary fields? Have you thought about moving those metrics to a separate sheet instead of trying to replicate the entire source data set?

  • CoryG
    CoryG ✭✭

    Moving to another sheet is not a bad idea actually how would you call that data into its own sheet? For instance if I have this formula here:

    =COUNTIFS(Batch:Batch, "2", [Declined / Deferred?]:[Declined / Deferred?], ="")

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    You would use the same exact formula but create cross sheet references for the ranges.

    Start typing:


    In the formula helper box you will see a little blue link that says something along the lines of "Reference another sheet". Click on that, and another window will automatically open.

    Find the sheet that contains the source data, click on the column header of the column you want to reference, (optional) rename the reference so that it is easy for you to read, click on the blue button in the bottom right corner of the popup to Insert Reference.

    The window should now close taking you back to the metrics sheet where you should now see

    =COUNTIFS({Range Name}

    From here you just continue with the formula as usual creating additional cross sheet references as needed.