Google Sheets: Sync Data from One Sheet to Another

[GrowWithChintamani]

00:04 Sync data from one spreadsheet to another with restricted access.
00:55 Create a new spreadsheet and share with specific users
01:35 Use IMPORT RANGE function to sync data from master spreadsheet
02:21 Sync data using importrange formula
03:08 Copying specific data from one sheet to another
03:49 Sync data from one sheet to another
04:29 Sync data between Google Sheets
05:13 Using import range formula to sync data

Thank you so much dear Jason Aillaud ❤

[nirupamajoshi]

Brilliantly explained.I never knew such a complicated task can be done so easily.Thanks! From India.

[LailaAdassi]

Thank you!
Now, what can we do about formatting? I have checkboxes in my master, and conditional formatting ?

[SusanSelle-vw]

Thank you so much! I have been looking for a tutorial on how to link to dynamic data. This is perfect! Also, being from the PNW originally, it was fun seeing some familiar town names on some of the teachers' tabs. :)

[JasonHouse]

How would I incorporate an "IF" into this formula so that only fields with a certain value within the imported range show?

[LyndsayMorris-wb]

How do you get it to also copy the formating from the master spreadsheet to the other spreadsheet?

[lika]

Thank you for the info!! Can you sync from tab to tab on your worksheet? I would like to have a master tab and my data added to other tabs. Is this possible using the formula without creating a new google worksheet?

[bittermaxx]

also works if you choose only one cell and not a range!! Thank you! :)

[martinbuschman]

Awesome - thank you for this - was looking for this function for ages and you explained it really well - all working for me now!

[LilianaVargas-gc]

Amazing!! Thank you!! I followed along with you step by step and it worked!

[jasmined]

Thank you so much 🎉🎉🎉🎉 finally found a video that showed step by step and it worked 💪 🙏 🎉🎉🎉

[JohnMarkadakis-ch]

If we do this, can you re-arrange the columns in the new sheet and keep everything working well? What about sorting the data by column?

[ChuuMong]

Thank you for this- however, formatting (such as colored cells, collapsed rows, etc) does not carry over. Is there a way to preserve formatting?

[Nat.N...]

Lovely. Lets say that on your master sheet you have columns A-W. However, on the sheet you want to share colums that are not right beside (e.g, A, B, D, E, F, J, R, S) how would you do that?

[dmjasper]

THANK YOU! Your instructions and video is just what I needed

[zzaawwcc]

This was so helpful and you explained it very well. Thank you so much!

[samuelagina]

This just explains it perfectly.
Thanks a lot for the effort.

[lynnebossart]

How would you include ranges and various single columns, e.g., A-E, H, J?

[kidsnurserytrainingvideos]

Thankyou so much ...most easiest way u explained it.

[ms.josmarya]

Thank you! I really enjoyed the pacing of this video and I also would like to ask if there is any way that the formatting can also be transferred to the new document. I have some places colored coded and it would be a headache to go back and do it manually to the shared spreadsheet. Can you assist with this?