Skip to main content

I have duplicated a Google sheets sheet (Sheet A) to another Google sheets sheet (Sheet 😎. I am trying to duplicate any changes in Sheet A to Sheet B. This seems like it would be super easy but I am running into issues. I am able to update a single row or copy a new sheet upon changes but I just want to simply Mirror Sheet A to Sheet B. 

Will someone provide a link or a provide a guide?

Thank you. 

Hi @Dustin Gurley 

One workaround would be to use an IMPORTRANGE formula in the GSheet: https://support.google.com/docs/answer/3093340?hl=en

NOTE: This depends on whether the data in both GSheets should be editable.


@Troy Tessalone Thanks for the insight!!! That does seem to work 🙂 but it does remove all formatting. :(
Do you think any solution in zapier would keep formatting?

Thank you again. 


@Dustin Gurley 

What sort of formatting are you referring to?

Perhaps provide examples.


Thanks again for all of your help. I have been able to navigate around it with conditional formatting, I was just hoping formatting would copy over as well as to only have to setup conditional formatting in one place.

Thanks!