Awesome - thank you for this - was looking for this function for ages and you explained it really well - all working for me now!
@user-ru1wp4bt9q Жыл бұрын
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. :)
@GrowWithChintamani6 ай бұрын
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 ❤
@samuelagina110 ай бұрын
This just explains it perfectly. Thanks a lot for the effort.
@zzaawwcc11 ай бұрын
This was so helpful and you explained it very well. Thank you so much!
@nirupamajoshi34982 ай бұрын
Brilliantly explained.I never knew such a complicated task can be done so easily.Thanks! From India.
@user-wt4bp1me3o3 ай бұрын
Amazing!! Thank you!! I followed along with you step by step and it worked!
@stephybug Жыл бұрын
Woo! Didn't know I needed this....thanks so much for sharing!
@user-kd1fg8zc4s Жыл бұрын
Thank you Jason! This was very helpful!
@alvaroromero7679 Жыл бұрын
Jason thanks a lot for sharing this information!
@cct4372778 Жыл бұрын
Thank you so much. Appreciate. Love from Malaysia.
@SidsTips8 ай бұрын
Thank you! Just what I was looking for!
@sa0bmc5 ай бұрын
This is awesome. Thanks! You just helped me with a project.
@michaelparado3505 Жыл бұрын
I love it thankyou! for making this
@philocac5424 Жыл бұрын
thank you, followed your steps and it worked! :)
@alexrandolph228711 ай бұрын
Great video Jason! Thank you
@junoesq Жыл бұрын
Thank you!!!! This video is so helpful!
@PuddingMamba Жыл бұрын
Very helpful! Well done!
@bittermaxx3 ай бұрын
also works if you choose only one cell and not a range!! Thank you! :)
@jasmined69494 ай бұрын
Thank you so much 🎉🎉🎉🎉 finally found a video that showed step by step and it worked 💪 🙏 🎉🎉🎉
@leivaz_9 ай бұрын
nice, worked for me, saved lot of time!
@user-cy7ed6wg7p3 ай бұрын
Thank you for this tutorial! It works!
@lvmiswthrt11 ай бұрын
thank you for made my day
@kidsnurserytrainingvideos65748 ай бұрын
Thankyou so much ...most easiest way u explained it.
@clkb8moto2 ай бұрын
Brilliant! Thank you.
@KennethGirasol7 күн бұрын
life saver and a huge time saver!
@indusmusicdocuments6915 Жыл бұрын
Thank you sir, It's really really helpful for me...
@markchadbourne80494 ай бұрын
Great tutorial. Thank you 👍
@JoshuaHines Жыл бұрын
Great video!
@santcash29 күн бұрын
Awesome! Thank you so much!
@user-lp4rn2dp6p3 ай бұрын
nice short correct explanations. thanks
@JosephWong-kx3oi Жыл бұрын
Excellent !!
@user-xr6xt8en5g8 ай бұрын
Thank's for tutorial!, best regards
@abhinaysingh40937 ай бұрын
Very helpful, Thanks for sharing this video
@ms.josmarya1858 ай бұрын
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?
@susheela7737 ай бұрын
Thank you so much!
@joshaquino8189 Жыл бұрын
legend
@KatherineJhoccyАй бұрын
Thanks so muuch. You save me
@shereenhorton60567 ай бұрын
Perfect! Exactly what I needed. Wondering... is there a way to have changes go both ways?
@ddollentas9180 Жыл бұрын
thank you!!
@calebswallow8984Ай бұрын
THANK YOU!!!
@samirhicham25902 жыл бұрын
Thank you Jason (y)
@shahbazkhan2283 Жыл бұрын
Love u Man
@10000suraj6 ай бұрын
you are great
@abhishekshakya2266 Жыл бұрын
Thank you so much boss
@robertasomerville162 Жыл бұрын
Will this keep adding new info from another spreadsheet? I have one live sheet that is updated all the time. I need to have the info come over on it's own each time it's looked at. Also I need to have a different sheet for each one of the options in a column. Basically a page of into for each work station(that's listed in a column).
@priyanshu2021 Жыл бұрын
Thannkkkkkkkk youuuuuuuu sooo sooo much
@TuhinMadhu-di9vn18 күн бұрын
Thank You Sooooooooooooooooooooo Much
@nesioraul Жыл бұрын
I keep track of my hours at work, and i have some cells with year to date. Is there a formula were i can add YTD from sheet 1 to new payweek on sheet 2 automatically, and dates aswell?
@joannetrojillo20287 ай бұрын
Thanks!
@susannahcoleuk10 ай бұрын
thank you
@LailaAdassi Жыл бұрын
Thank you! Now, what can we do about formatting? I have checkboxes in my master, and conditional formatting ?
@leosmi110 ай бұрын
THANK YOU
@yousuf.r.49285 ай бұрын
Thank you very much 👍🙏👍🙏👍🙏👍🙏
@dangleroАй бұрын
Well, 2 years later and it still works, so that is awsome! If anyone sees this, is there a way to also import with formatting like cell highlights, alternating colors, etc.?
@johnirving71047 ай бұрын
@jasonaillaud1638 Well done! What is the formula to share specific columns that are not next to each other, for example A1:C F1:H, thanks
@Lyrical2636 ай бұрын
Thanks 🎉
@erichepperlewpАй бұрын
Hi! Great tutorial -- Where are the written directions you said you'd attach in the description?
@giovannipiris52852 жыл бұрын
Can you edit the data that contains the importrange function ? In other words a two way back and forth sync between the two spreadsheets. Thanks, good tutorial
@asiagrecruit Жыл бұрын
No i guess because, i tried but no changes in parent sheet
@unveilingheirsparents Жыл бұрын
Is there a way to do this where Teacher 1 can make edits to their sheet that will update to their information on their respective tab on the Master?
@user-ek8pt3yg7c9 ай бұрын
How do you get it to also copy the formating from the master spreadsheet to the other spreadsheet?
@sukritijha272Ай бұрын
😂
@TheLooking4sunset11 ай бұрын
A question, what if teacher one was stalking his colleague and went in and edited the reference so that she could see data from unintended tab? How do we go against that?
@melodykan11079 ай бұрын
Thank you so much. However, I found it only bring the text, not the back ground color nor the format. how can I bring those as well ?
@lynnebossart4771 Жыл бұрын
How would you include ranges and various single columns, e.g., A-E, H, J?
@supakimmo Жыл бұрын
yeah! could we have a little help with this question?
@pushstart2733 Жыл бұрын
Were you able to find the solution?
@shahbazkhan2283 Жыл бұрын
May be u first hide those columns u don't require. I don't know but maybe it can work. Give it a try
@user-it1hd8zl6g7 ай бұрын
Hello Jason, This video finds me quite helpful. Here I have some questions regarding this 1 Does changes in original spreadsheet will change in another sheet in which we copied data and make dynamic ? 2 I have total 92 columns starting from A to CM so for this which range should I have to enter in formula to make changes respectively For example : I have changed the value in C column. Will this changes in value will reflect in sync sheet (automated sheet) Please help me here Thanks
@user-it1hd8zl6g7 ай бұрын
Also I want to lock the first three columns of spreadsheet and changes in another sheet can also do change in original change So for this what to do? Which formula will working? Please suggest
@zaclaplant30013 ай бұрын
What about formatting? What about being able to edit the second sheet separately from the first sheet as needed
@BazingaRhymes6 ай бұрын
Thank you
@curtclapier4353 ай бұрын
Thank you so much. What if I want it to sync the formatting from the other spreadsheet. Is that possible?
@JasonHouse8228 күн бұрын
How would I incorporate an "IF" into this formula so that only fields with a certain value within the imported range show?
@sudarshanshetty96638 ай бұрын
Can you give time to sync data . I mean want sync data in full day for limited time or particular time
@ALAMEXICANA5 ай бұрын
Thank You so much For This video !! how about if i want to import data From Master sheet to a specific Sheet based on the name of the Sheet ?
@otarshamanadze25583 ай бұрын
is it possible to copy the formating from the master spreadsheet to the other spreadsheet?
@jommyknots90912 ай бұрын
It ia possible when the destination file automatically "insert new sheet" when the source file "insert new sheets" too ?
@umarferoz7489 ай бұрын
helpful
@thefaraon6079Күн бұрын
Any idea how to make it so the information goes onto the next column after you are done typing. Because i am trying to make a form on one sheet that fills another with the inputed info
@Yogeshsai65 Жыл бұрын
I am not able to do this as it is showing "Cannot find range or sheet for imported range." to me, could you please help me to find the solution
@ammarahbashir65342 ай бұрын
What about in the same sheet for the different sheet tabs?
@ngominhquang81616 ай бұрын
When it shows the #REF error and I hover onto the red button, there isn't any option to connect sheets. Also is there a way to sync only 1 cell?
@GauravKumar-ui7ow4 ай бұрын
Try mention that particular cell say A1 , in that place in formula bar
@ArmadusMalaysia8 ай бұрын
Hi, is there a way to do this on android phone or tablet? There is no button showing called "allow access"
@pushstart2733 Жыл бұрын
Thank You very much for sharing this. I tried, and the current data got copied, but I cannot see the newly added data.
@polaroiddiva2 ай бұрын
Excellent! I also want to import the data from just one cell (not a range of cells) from one Google Sheet to another. I am trying to use your formula, but keep getting an ERROR message. Don't know what I am doing wrong.
@sharonstark80363 ай бұрын
This imported the data for me but not the formatting, is there a way to also include the formatting?
@itsluis7 Жыл бұрын
what if you want all cells to be copied even if theres more added?
@Concordia-zobarstnieciba8 ай бұрын
Hi! I have message "You don't have permissions to access that spreadsheet." I am bit confused because both files are in the one G Drive folder and it is my G Drive account. Do have any idea how to get "permission"?
@bofferbrown5 ай бұрын
same
@DangerBrick2 ай бұрын
You need to be the owner for that to work.
@irenemukulu6472 Жыл бұрын
I need help please. I just noticed that I cannot work on my google sheets excel because offline access is enabled for another user. How can I fix this?
Did anyone get the answer about how to include the formating??? Ie: colored cells text being centered?
@DavidAmores-wo7dvАй бұрын
The excel works, but I need to refresh the site in order to sync the data from the other if I wanted it updated always. How do I fix this?
@cynthiabell17347 ай бұрын
How do I make it keep the original formatting?
@iammichaelhughes Жыл бұрын
How do you find duplicates on sheets with the imported data? Countif is not working on the imported data.
@kyleriley97868 ай бұрын
Try the unique function
@monikadhomase9851 Жыл бұрын
Thanks for such video but i m not able to since column data more than 8 column, could you please guide
@MFTW Жыл бұрын
2:15
@user-hr9hy9it7q2 ай бұрын
it copies the raw data without the formating, how do i fix that?
@markveranarn4 ай бұрын
Hi po may tutorial kau mag automate Ng sales every week for 4 weeks until ma hit nila ang 100 sales automated and automatic na ma remove sila SA board to be promoted as a trainor
@TebusRamos6 ай бұрын
Hi, I keep seeing the following : "you don´t have permission to access that spreadsheet" How Do I overcome this?
@bofferbrown5 ай бұрын
same
@mylenrodes62192 ай бұрын
what to do f it says you dont have permissions to access that spreadsheet
@Swati-il9ii7 күн бұрын
U can add that sheet which you have access
@yuvarani913110 ай бұрын
Videos not clear sir please upload new clear video