Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.
10000+ Copies Already Downloaded
In my starting days with Excel, I was really bad in capturing data.
If you asked me to capture sales data for four different zones, I will create four different worksheets for that. Yes, I was really bad.
But, you always learn with your mistakes. Am I right? And, if you are doing the same mistakes like I did, I have an amazing tip for you.
In this post, I will show you how to consolidate data from multiple worksheets in a single worksheet.
We have these four worksheets here for four different zones which have the same structure.
And, we want to consolidate all these worksheets in another worksheet.
Finally, you have consolidated worksheet.
Consolidate is a handy tool to consolidate data from multiple worksheets in a single worksheet.
But, we have a lot of other things in this option.
Let me explain it one by one.
In the end, I just want to say, it’s an awesome option to use to consolidate data. The best part is you can capture N number of worksheets with it.
You also have different functions as well.
Otherwise, if you go with the manual method to sum all the worksheets, it’s a pain.
Have you ever did mistakes like I did?
Please share with me in the comment box.