3

Basically, I have a huge list of data on Google Docs spreadsheets, and a bunch of people that read it. They are not tech savvy. I am trying to create duplicate sheets on a Google spreadsheet that are filtered copies of a master sheet, in order to increase readability for the other collaborators, and that when a row is modified on one of these filtered sheets, will update the corresponding row on the master sheet. Any ideas?

3

How to automatically pull data between different Google Spreadsheets:

There is a function called ImportRange that allows you to pull data out of one sheet and into another. This can be really useful, if for example you have a spreadsheet that you are using to collaborate with others, and then somewhere along the line you want another person to be able to see some of the data in the sheet but not all of it. e.g. if you are using this to track student grades, you could have a master sheet that you and other tutors can see all of, you could then create a separate sheet for each student, and pull through only the data that refers to them (you then share that sheet with the student) and they have a live constantly updating record of what they have achieved etc.

  • ImportRange is a live link, so data changed in the master sheet will "immediately" show in the linked sheet. The linked spreadsheet has to have permission to see the data in the master sheet. – Andrew Jens Jun 29 '17 at 5:52

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

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