For the last few posts, I have been writing about data consolidation – Various ways possible of consolidating in Excel. I was getting a lot of queries on the same so thought of putting all those in a single place. This is the consolidation of all the previous post on the topic. You will also find sample worksheets with illustrations under each posts.  Don’t forget to do your home works with those .

To summarize data from separate worksheets, you can use the data consolidation tool in Excel. The worksheets can be in different workbooks or in the same work book. There are two types on consolidation possible with this. One is consolidation by position and the other is consolidation by category. This is a very useful tool in Excel which will help in data consolidation. We will see detailed illustration on how to do this in Excel 2007.