ENTREPRENEURSHIP

Detailed explanation-1: -Each column must have a label (header) in the first row and contain similar data. There must be no blank rows or columns anywhere in the list. Put each range on a separate worksheet, but don’t enter anything in the master worksheet where you plan to consolidate the data. Excel will do this for you.

Detailed explanation-2: -Use Merge Worksheets to combine two or more open worksheets into one new worksheet. There are two ways to merge worksheets: side-by-side or match values. Stored constants, matrices, DOE objects, formulas, and worksheet descriptions are not transferred into the merged worksheet.

Detailed explanation-3: -Open the original Shared Workbook into which you want to merge changes. Click the Tools menu and then select Merge Workbooks…. If prompted, save the workbook. In the file navigation dialog box, click the copy of the workbook that contains the changes you want to merge, then click OK.

Detailed explanation-4: -Open each source sheet. In your destination sheet, click the upper-left cell of the area where you want the consolidated data to appear. On the Data tab, in the Data Tools group, click Consolidate. In the Function box, click the function that you want Excel to use to consolidate the data. More items

Detailed explanation-5: -Open the workbook that contains the sheets that you want to merge. Click the sheet that you want to be the first sheet in the merged workbook. Hold down the Shift key, and click the last sheet that you want to include in the merged workbook. More items