What do you suggest in including a unique key in the consolidated one only? Because the new entries in the live file will constantly move and it is hard to generate a unique key for them.
Can you add a column A (move everything over 1 column) and add the name of the Tab it is from? So each row shows if the data if from Part 1, Part 2, or Part 3?
I'm getting the same error. I think it's happening because we are taking a lot of information, so google sheets are not able to process. If you already did it please tell me
This is a google sites question: I added a widget for google reviews, but the height set but the widget is too big , is the a way to adjusted when I embed the link in google my sites? I hope you can comment. Thanks
is there a solution to change one cell such as adding a formula that will copy the same information to the entire worksheet? In excel, you select multiple tabs and make change, however that does not work in sheets. Every worksheet is exactly the same. Thank you in advance and this video was very, very helpful. I have subscribed.
Can we add new datas at the top row but inserting a new row? Whenever I add anything at the top, it does not reflect in the mastersheet but it only reflects when I add at the bottom.
I spent the whole day looking for a tutorial like this one and it helped me a lot, thanks. You've got yourself another subscriber 👍
Thank you! and welcome to the community!
SO EXCITING!! This will help so much, I have so much assessment data and it was getting out of hand. Can't wait to get it back under control!
The new studio looks amazing! Great to see you back in action!
Yes! Thank you! It's great to get back to making content.
What do you suggest in including a unique key in the consolidated one only? Because the new entries in the live file will constantly move and it is hard to generate a unique key for them.
Once you have your master list, can you then sort the columns from A to Z etc?
you can, but you'd have to write it in the query formula
very helpful. nicely explained. thanks!
This is extremely helpful! Is there a way to do the master and remove any duplicates?
I want to do the exact same thing but from different work books..how I can do that?
Really Helpful, thank you for your great effort
Can you add a column A (move everything over 1 column) and add the name of the Tab it is from?
So each row shows if the data if from Part 1, Part 2, or Part 3?
how if I dont want the same name to be repeated in the master list, what formula we can use on top of what you have show?
Does not work
i'm getting this error
#REF!
Error Function ARRAY_ROW parameter 2 has mismatched row size. Expected: 215. Actual: 546.
I'm getting the same error. I think it's happening because we are taking a lot of information, so google sheets are not able to process. If you already did it please tell me
GReat how you make sheets look so simple. Thanks again, Sethi!
You're welcome 😊
Very Useful for me Thanks
So grateful for your help. Amazing!
This is a google sites question: I added a widget for google reviews, but the height set but the widget is too big , is the a way to adjusted when I embed the link in google my sites?
I hope you can comment.
Thanks
this was great! HOw can I alphabetize the master sheet?
New subsciber here. I think I'm gonna learn a lot on your channel. I'm currently self-learning and is planning to use these skills at work.
It's great to hear that! Welcome to our community, and I'm glad to hear you are finding the videos helpful.
Great tutorial, this exactly solves my problem without installing any add-ons. Thank you so much.
Cant help my index finger! It clicked "Subscribed"!!!
Thanks for this!
Thanks for subscribing!
tq sir. i have think this for 1 month. but watching ur video for 7 minute is clear everything❤
Great 👍 Thank you for those kind words!
Thank you very much. You are a good teacher
is there a solution to change one cell such as adding a formula that will copy the same information to the entire worksheet? In excel, you select multiple tabs and make change, however that does not work in sheets. Every worksheet is exactly the same. Thank you in advance and this video was very, very helpful. I have subscribed.
Thank you for the technique!....
You're welcome
Thanks for the link to Ben's spreadsheets page.
No problem! It's an amazing resource to have!
This tutorial is very informational and easy to follow! Thank you so much 🥺
Thank you!
great easy tutorial
🎉Woohoo, first to comment on another amazing tutorial 🏅
Yay! Thank you!
Well explained from India
Thank you!
Thank you very much for the technique that I can use in my office work...
Glad it was helpful!
Great tutorial
Still useful! Thank you.
Glad to hear it!
amazing video, thank you so much!
Glad you liked it!
Thank you! very helpful
Glad it was helpful!
That's beautiful ! thank you
Glad you like it!
Can we add new datas at the top row but inserting a new row? Whenever I add anything at the top, it does not reflect in the mastersheet but it only reflects when I add at the bottom.
thank you!
Amazing
Thank you!
👌 P r o m o s m