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.
Worth $20, Absolutely Free
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.
I was that 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.
One of the best Excel options which I have learned about managing data is to “Consolidate Data From Multiple Worksheets in a Single Worksheet”.
And today, I’d like to share with you this method.
The best part with this method is, you don’t need any VBA/Macro code. It’s just a simple option to combine data from multiple sheets.
So let’s get started.
You have these four worksheets here for four different zones which have the same structure. Now, you need to consolidate all these worksheets in another worksheet.
Download this sample file from here to follow along.
Once you click OK, it will instantly give you a consolidated data table with the same structure.
Add table heading in cell A1. You can also use format painter to copy formatting from other worksheets.
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 consolidate data within seconds. The best part is you can capture N number of worksheets with it.
If you go with the manual method to consolidate data from multiple worksheets is a real pain. You know, doing one by one or using formula.
I hope you will get better in your work with this tip.
Now tell me one thing. Which method do you use for this? Please share with me in the comment section, I would love to hear from you.
And, please don’t forget to share this tip with your friends.