1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.
If you have related data spread out over a number of locations, it can be difficult to keep track of it as you flip back and forth between the different worksheets. One way to simplify such a situation is to create a summary sheet using the consolidate feature.

This feature allows you to combine the data from different worksheets or even different spreadsheets onto a single page.

In addition, when consolidating data, you have the option of creating a link between the new worksheet and the original data sources. When linked, any changes to the original data are transferred to the summary sheet as well.

To find out how to use the consolidate feature, watch the video on how to Merge Spreadsheets in Excel.

Related Videos
November 12, 2010 at 4:05 pm
(1) Kathy says:

very good demo.

May 4, 2012 at 2:45 am
(2) bort says:

wish there was a text version..

July 16, 2012 at 11:48 am
(3) Arden says:
July 24, 2012 at 1:52 pm
(4) Lou Gruninger says:

What if the data you are merging has other non-numerical data in it outside the header and left column? I want to combine a list of employees and it also has job descriptions and salary grades that are text along with other text data.

November 20, 2012 at 7:04 am
(5) S. Pasban says:

Sub CopyAllSheets()
MsgBox “Starting to copy” + str(Windows.Count – 1) + ” workbook”
For i = Windows.Count – 1 To 1 Step -1
S = “Book” + Trim(str(i)) + “.xlsx” ‘change your workbook names
Sheets(“Sheet1″).Copy After:=Workbooks(“pasban.xlsx”).Sheets(1) ‘copy into a new workbook named pasban
MsgBox S + ” PASTED!”
MsgBox “DONE.”
End Sub

Leave a Comment

Line and paragraph breaks are automatic. Some HTML allowed: <a href="" title="">, <b>, <i>, <strike>

©2014 About.com. All rights reserved.