How can I import the whole sheet to another Google spreadsheet?

Question

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.

Riël · Accepted Answer · 2015-09-05 13:44:18Z

1

This is possible with importRange use

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

answered Sep 5, 2015 at 13:44

Riël

1972 bronze badges

Add a comment |

1 Answer 1