{"id":963,"date":"2012-07-05T19:43:00","date_gmt":"2012-07-05T11:43:00","guid":{"rendered":"http:\/\/vm-officeblogs.cloudapp.net\/2012\/07\/05\/score-merge-data-from-multiple-worksheets\/"},"modified":"2022-06-28T10:25:17","modified_gmt":"2022-06-28T17:25:17","slug":"score-merge-data-from-multiple-worksheets","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2012\/07\/05\/score-merge-data-from-multiple-worksheets\/","title":{"rendered":"Score! Merge data from multiple worksheets"},"content":{"rendered":"

\"Soccer<\/h3>\n

The Decatur Golden Gators soccer team is hitting the pitch (that’s a field<\/strong> for you uninitiated folks) to perfect their skills and beat their better-funded rivals. The coach is excited and fiscally worried. Lining up mini-vans, buying snacks, and replacing torn jerseys is not cheap!<\/p>\n

Rolling these expenses into one worksheet is also pushing the limits of his Excel skills. He has different worksheets for transportation, treats, website hosting — he cuts and pastes numbers from each into his overall budget. Inevitably, Cntl + C leads to errors.<\/p>\n

The Excel Consolidate<\/b> feature provides an easy way for the coach to merge his data from different worksheets into a main worksheet, allowing him a more complete view of his expenses (in fact, he can merge up to 256 worksheets!). By using the Consolidate <\/b>feature, <\/strong> the beleaguered<\/span> coach can get a handle on team expenses and better focus on motivating the squad.<\/p>\n

The steps for merging, or consolidating, data are pretty straightforward. Here’s how to do it.<\/p>\n

Set up your workbook <\/h3>\n

You can use our sample workbook<\/a> or if you want to learn by creating your own workbook, be sure to do the following:<\/p>\n