Thank you sir for this, it is indeed amazing, however, I would link to know if it is possible to share only a single sheet without changing the formatting of the original sheet
This works BUT, I can't add anything. If I add something everything disappears b/c it's not referenced correctly. How can someone share one tab and both people be able to work on it and change it?
This would be great if both master and copy could be updated. I need my employees to be able to add information as they go but need each employee to be private. This only works with me sharing info with them not in reverse.
Question: When it imported into the new sheet, it only imported the cell data but none of the formula's, colors, etc. How do I make sure it copies the exact sheet?
If you are losing the formatting when you import the only way to format like the original may be to use the paint format tool to manually copy the formatting from the original to the new one.
Great video! Question---on the new sheet---will the person be able to make edits and will those be reflected back on the initial sheet with all of the tabs?
@@ModernSchoolBus When I use Importrage it shows I don't have access to the sheet instead of allowing access, where I am the owner for both files. how to provide that access
@@jithinalunkal If you are the owner of both sheets you should be able to allow access just like in the video at 2:50. You will have to make sure you are the owner of both sheets in the same gmail account. I would double-check your spreadsheet URLs if this isn't working because it should work just like in the video
The new sheet is just imported so you would have to edit the original to change the new sheet. If you really want to edit them separately, you would just need to copy the new sheet and paste as value to remove the formulas so that they are no longer linked
it does not copy the formatting - is there a way to also copy the looks and formatting of the original sheet?
Copy everything from the tab, paste it (with looks & formatng), clear all the cells, then put the function on the A1 cell
I want to share a single sheet,
With a single editable cell (users can select from the drop down only )
Thank you sir for this, it is indeed amazing, however, I would link to know if it is possible to share only a single sheet without changing the formatting of the original sheet
This works BUT, I can't add anything. If I add something everything disappears b/c it's not referenced correctly. How can someone share one tab and both people be able to work on it and change it?
This would be great if both master and copy could be updated. I need my employees to be able to add information as they go but need each employee to be private. This only works with me sharing info with them not in reverse.
Is there a way around?
Question: When it imported into the new sheet, it only imported the cell data but none of the formula's, colors, etc. How do I make sure it copies the exact sheet?
hello, how can i make the shared sheets editable and will automatically update the original?
You can't edit the shared sheet's imported data.
But does the data update on the new sheet if you change it from the original?
Yes, it will auto-update
Is it possible to share only one tab of parent sheet without creating child sheet....?
*Is it possible to share only one tab of a google sheet with editing permission and not share the whole sheet?) (while staying in the same sheet)*
So this will allow shared user access as editor or veiwer only?
I tried to do this but it keep saying "You don't have permission to access that spreadsheet" i.e the primary spreadsheet. what should I do please??
The section at 2:50 and the section at 3:19 in the video show allowing access to the sheets. I'm not sure which one will solve your issue.
How do I keep the sheets formatted like the original one when it is shared?
If you are losing the formatting when you import the only way to format like the original may be to use the paint format tool to manually copy the formatting from the original to the new one.
@@ModernSchoolBus I need the same thing as this person, but I also need my validations and locks to copy over as well.
Great video! Question---on the new sheet---will the person be able to make edits and will those be reflected back on the initial sheet with all of the tabs?
If in new sheet we will add new subsheet it's also link with master sheet?
is there any way to make it directly with code?
Very Useful
Muchas gracias!
Great, Thanks, Realy a big help!
Perfect. it worked.
you the man
Thank you bro!
Thanks buddy ❤
Glad you found it useful!
Hey, when you import it into a new sheet to share, but then you update the original, will it update the new sheet? thanks :)
Yes, it will update in the new sheet if you make any changes to the original one.
What about in reverse? If the second sheet is updated, will the master be updated as well?
@@mpom711 No. The second sheet is imported from the first. So changing the second sheet will never update the first.
@@ModernSchoolBus When I use Importrage it shows I don't have access to the sheet instead of allowing access, where I am the owner for both files. how to provide that access
@@jithinalunkal If you are the owner of both sheets you should be able to allow access just like in the video at 2:50. You will have to make sure you are the owner of both sheets in the same gmail account. I would double-check your spreadsheet URLs if this isn't working because it should work just like in the video
Thanks!
Thank you
Is there two way editing on both the new sheet and the old sheet? I attempted to edit the new sheet, but it gave me an error?
The new sheet is just imported so you would have to edit the original to change the new sheet. If you really want to edit them separately, you would just need to copy the new sheet and paste as value to remove the formulas so that they are no longer linked