How to use the consolidate function in Excel.
Combine data from different sheets. Combine data from different files.
Check out my online courses
Become an Affiliate and earn 25% on Course Sales
For more help visit my website or email me at easyexcelanswers@gmail.com.
Contact me regarding customizing this template for your needs.
Excel one-on-one on-line training available. Email me to arrange.
I am able to provide online help on your computer at a reasonable rate.
Check out my next one-hour Excel Webinar
I use a Blue condenser Microphone to record my videos, here is the link
Check out Crowdcast for creating your webinars
If you need to buy Office 2019 follow
I use Tube Buddy to help promote my videos
Check them out
Follow me on Facebook
TWEET THIS VIDEO
Follow me on twitter
easyexcelanswers
IG @barbhendersonconsulting
You can help and generate a translation to you own language
*this description may contain affiliate links. When you click them, I may receive a small commission at no extra cost to you. I only recommend products and services that I’ve used or have experience with.
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
Thank you!
It's very helpful man, thanks a lot for posting videos like that. i got a question how did you select all these sheets in one touch
Seeing as this video is pretty old, I'm not sure if you still answer questions, but I have one. I followed your instructions and it worked perfectly so thank you, however, my sheet has both %'s and $'s in it. The dollars are summed, but I don't want the %'s to be summed. For example, $1000 on each of 3 sheets is totaling to $3000, but that's also showing at 300% and it's really 100%. Can this be done where you have multiple functions? Also, can you eliminate the groupings on the side of the sheet so that one can't see what makes up the total unless they look at the individual sheet?
Why are they all named Book 3 though? I'm guessing it's because we can consolidate different files as you said, but can we automatically change them to their sheet names?
You saved me🥰
How i get this page
Is anybody Indian here
oh ! thank yoou so much i gotta get marks by u !!!
Cheers
Thanks! I forgot how to do this!
How to change the name of worksheets from book1 to horse1?
nice and awesome pr short n sweet
Thank You! This helped me.
Thanks for it ✨
Quick, easy , & to the point.
thank you, good summary!
Great review of the function, thank you!
Barb, simply thank you for your kind help online. Major respect coming your way for sure!!!!!! 🙂
Hi, can I use consolidate to find same information on multiple spreadsheets? I'm looking for a way to compare data in multiple spreadsheets using a unique identifier so that I can see who is on these lists and who isn't.
When I select Create Links to Source Data, the data is not automatically updating. Can you tell me how to get the data to update automatically when I update a sheet?
Thanks
Cute and useful example. Ty!
Thank you, Barb! This really saved me tonight! Also, I really appreciate your pleasant and warm delivery. 🙂
Hello
I have like two columns with PIN and Serial number respectively. I want to consolidate them into one cell where it will be like one on top the other below for like hundreds of data. How do I do it?
nice
what should i do… Actually I have two excel… One excel given by my party and second excel maintained by me…. now I want to compare Both execl bil….
Suppose I have maintained 10 parties having 10 bills… i.e. 10 bill purchase is in name of each party… but the excel given by party can only maintained 10 bill of 8 parties… now i want to compare that…. i used filter… but noe I want that function in which it make group of name automatically with sum of amt… For example Mr.x group Mr y group…. Is it possible
Hi my my teacher say talk about consolidate which can I say in a sentences thank you can you answer me
Each time new data coming after refresh. I don't wnt to manually consolidate each time. Tell me some other way
how do I isolate repeated names from 2 different spreadsheets?
Thank you!!! This was SOOOOO helpful!!!
Awesome 👏
wow i love you!!!
how to sum the amount with multiple duplicate orders? Example; duplicate orders and has different total and would like to sum it so the duplicate order can be delete.
Or how do I collect data that is in a column with blank cells between them? To go from a column with blank spaces to a new column identical data with no spaces
I have a question about figuring out average trip times. I have a spreadsheet with a bunch of trucks and there begin and end journey times are in same column and I want to find a way to auto calc the average time. I could send you my sheet