I have a sheet (sheet1A) in Google spreadsheet A, and another spreadsheet - spreadsheet B

Now I want to have another sheet on B - called sheet1B - that's totally the same as sheet1A, with data get updated from 1A.

Because sheet 1A is under other person's control, I just want to have another place to take control of the data I get from A.

1 Answer 1


This is possible with importRange use

=IMPORTRANGE("sheet id"; "range") function.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.