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?
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.
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.
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
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
![[MV] A leap of faith...ความเชื่อใจครั้งสุดท้าย (From "Petrichor the series")](http://i.ytimg.com/vi/U1piZH2CNXA/mqdefault.jpg)
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!
This is extremely helpful! Is there a way to do the master and remove any duplicates?
Great tutorial, this exactly solves my problem without installing any add-ons. Thank you so much.
very helpful. nicely explained. thanks!
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!
Cant help my index finger! It clicked "Subscribed"!!!
Thanks for this!
Thanks for subscribing!
GReat how you make sheets look so simple. Thanks again, Sethi!
You're welcome 😊
This tutorial is very informational and easy to follow! Thank you so much 🥺
Thank you!
So grateful for your help. Amazing!
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.
The new studio looks amazing! Great to see you back in action!
Yes! Thank you! It's great to get back to making content.
Thank you very much. You are a good teacher
Once you have your master list, can you then sort the columns from A to Z etc?
this was great! HOw can I alphabetize the master sheet?
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?
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.
I want to do the exact same thing but from different work books..how I can do that?
Thanks for the link to Ben's spreadsheets page.
No problem! It's an amazing resource to have!
Thank you for the technique!....
You're welcome
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.
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 very much for the technique that I can use in my office work...
Glad it was helpful!
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?
Great tutorial
amazing video, thank you so much!
Glad you liked it!
great easy tutorial
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
Well explained from India
Thank you!
Still useful! Thank you.
Glad to hear it!
🎉Woohoo, first to comment on another amazing tutorial 🏅
Yay! Thank you!
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
Thank you! very helpful
Glad it was helpful!
That's beautiful ! thank you
Glad you like it!
thank you!
Amazing
Thank you!
👌 P r o m o s m