Hi, I have a question! Using importrange, i pull data from file A to file B. And if i edit A, B will automatically updated. How do i make it so if I edit B, A also updated? Is this possible? Please help!!
Google Sheet How to create a file where we have more than one data entry persons and wants to show separate sheet for each of them ? can we do that without creating new sheet for each person and final merge data with one sheet ? Big fan of your work doing good work
Hey hi. I had a similar need to yours. I have 4 nearly identical forms that feed a spreadsheet. I want to show each of the 4 fellows their data, but I don’t want them to see each other data. I have 4 tabs on this spreadsheet and only I have access to them. I have 4 separate spreadsheets each importing range from the correct sheet into this new sheet and that one is shared with them. Back on the master file I have a unifying sheet that merges all the 4 sheets toguether using query function and arrays. So your answer is: it’s easier to create separate sheets…. Alternatively: you could use one single file, different sheets inside it (pivot tables, queries, whatever pleases you) and share only that sheet online; it will generate a unique link that you could share. I’m not sure if I made myself clear, but índole it helps you.
I am entering payment amounts in one sheet and using these amounts to make calculations in another sheet after using IMPORTRANGE. At the bottom of each set I am calculating a total. From time to time, a new row will be added in a set on the first sheet. How do I get the rows to adjust in the second sheet?
It happened to me as well but the error code explains itself: it happens because the receiver is the import range function must have enough rows. The importance (for god knows what reason) won’t create new rows. You have to create them manually. Once undid create more rows i could make it work. :-)
To shorten the formula, you don't need the complete URL. For example you only the part after the "/d/" till the "/edit..." If this is your URL docs.google.com/spreadsheets/d/ULeZsnXjURFqeDGGW3LmVpsuZKUV/edit#gid=338809518 then only copy this Part in the Formula: "ULeZsnXjURFqeDGGW3LmVpsuZKUV"
It says that You don't have permission to access that sheet!!!!! where I'm the owner of both the sheets and those are shared with another person too. Please help me
After you import the data, then add a comment on column C for each row imported. the column C data and ColumnA, ColumnB does not sync when new data is entered to the A,B. how can you sync or link the rows. can you do a tutorial on this please.
@@ExcelGoogleSheets Thanks for replying. i love your videos. helped me so much. i was able to solve my problem by creating a unique ID along with a timestamp and using that as a reference while importing the data (all thanks to your videos. v much appreciated).
If someone updates the numbers in the 'source data' sheet and you don't have your intermediate sheet open on your browser, will you still have updated numbers on your final sheet? Assuming you only have the final sheet open.
The tutors wants other professionals to become corders. So he intent us to learn it the hard way. Therefore he won't provide his example sheets. That's what I understand 🤷🏽♂️
@@muhammedaadhil5645 Can’t agree more! Nothing like getting your hands dirty while attempting to recreate the examples shown, as you make mistakes you learn and more importantly when recreating we might most often come up with with a variation that more suits our actual requirements, well that’s my personal experience.
Thanks for sharing the great tip and we are waiting for Big Query video
i liked the mediator sheet ... its like protective shield to the main brain sheet
Excellent ! and direct to the point, I really liked the show.
VERY SIMPLE WAY TO EXPLAIN THANK YOU VERY MUCH!!!😊
Is there a way to import the range along with the formating of the data?
Hi, I have a question! Using importrange, i pull data from file A to file B. And if i edit A, B will automatically updated. How do i make it so if I edit B, A also updated? Is this possible? Please help!!
I have the same question. Any help would be appreciated
Not possible
Good tip! Thanks for sharing
Google Sheet
How to create a file where we have more than one data entry persons and wants to show separate sheet for each of them ?
can we do that without creating new sheet for each person and final merge data with one sheet ?
Big fan of your work doing good work
Hey hi. I had a similar need to yours. I have 4 nearly identical forms that feed a spreadsheet. I want to show each of the 4 fellows their data, but I don’t want them to see each other data.
I have 4 tabs on this spreadsheet and only I have access to them. I have 4 separate spreadsheets each importing range from the correct sheet into this new sheet and that one is shared with them.
Back on the master file I have a unifying sheet that merges all the 4 sheets toguether using query function and arrays.
So your answer is: it’s easier to create separate sheets….
Alternatively: you could use one single file, different sheets inside it (pivot tables, queries, whatever pleases you) and share only that sheet online; it will generate a unique link that you could share.
I’m not sure if I made myself clear, but índole it helps you.
This function is so cool! Thank you!
I am entering payment amounts in one sheet and using these amounts to make calculations in another sheet after using IMPORTRANGE. At the bottom of each set I am calculating a total. From time to time, a new row will be added in a set on the first sheet. How do I get the rows to adjust in the second sheet?
Excellent tip and great explanation, as always.
Thanks!
Hello, please help me!
Would you like to make the tutorial using excel online from one drive too? Because I've tried, but can't work
This is BRILLIANT!!!
I tried this with a sheet that has more that 100,000 rows and it fails.
It happened to me as well but the error code explains itself: it happens because the receiver is the import range function must have enough rows. The importance (for god knows what reason) won’t create new rows. You have to create them manually. Once undid create more rows i could make it work. :-)
@@HelenoPaiva Thank you for your reply. I couldn’t get you quite well. Is there a reference or video that explains that.
Thank you again 🙏 🙏
Thank you. Is therr a way to revoke the access from a spreadsheet?
I wish :)
Thanks for the tip, or you could use the protect cell/range/sheet? To restrict others from editing the formula.
What prevents them from copy/pasting the formula to a different unrestricted cell?
Thanks for the technique....
To shorten the formula, you don't need the complete URL. For example you only the part after the "/d/" till the "/edit..."
If this is your URL
docs.google.com/spreadsheets/d/ULeZsnXjURFqeDGGW3LmVpsuZKUV/edit#gid=338809518
then only copy this Part in the Formula:
"ULeZsnXjURFqeDGGW3LmVpsuZKUV"
How to automatically update the data in importrange sheet when we add new data into main sheet?
I don't Want to enter import range formula again and again for every new sheet... Any easy way?
It says that You don't have permission to access that sheet!!!!! where I'm the owner of both the sheets and those are shared with another person too. Please help me
Log out of your Google accounts and login back again using the right account.
Thank you so much.
After you import the data, then add a comment on column C for each row imported. the column C data and ColumnA, ColumnB does not sync when new data is entered to the A,B. how can you sync or link the rows. can you do a tutorial on this please.
Since it's auto generating formula, it won't be possible to make it sync. You would need to use some sort of script.
@@ExcelGoogleSheets Thanks for replying. i love your videos. helped me so much. i was able to solve my problem by creating a unique ID along with a timestamp and using that as a reference while importing the data (all thanks to your videos. v much appreciated).
Excellent!
I correctly put the formula but errors appear when I click the error no allow access appear...
IS ti possible you don't have sufficient access privileges to the spreadsheet you're linking to?
You don't have permissions to access that spreadsheet.
If someone updates the numbers in the 'source data' sheet and you don't have your intermediate sheet open on your browser, will you still have updated numbers on your final sheet? Assuming you only have the final sheet open.
Yes, it does update
@@davidfernandezbajo thanks!
KINDLY PROVIDE PRACTICE SHEET
The tutors wants other professionals to become corders. So he intent us to learn it the hard way. Therefore he won't provide his example sheets. That's what I understand 🤷🏽♂️
@@muhammedaadhil5645 Can’t agree more! Nothing like getting your hands dirty while attempting to recreate the examples shown, as you make mistakes you learn and more importantly when recreating we might most often come up with with a variation that more suits our actual requirements, well that’s my personal experience.