Tech Tip of the Week

Condensing Multiple Worksheets Into One

If you get workbooks that have identically structured data on each worksheet, you may be interested in a way to combine the multiple worksheets into a single, large worksheet. You need to copy the data from the second and subsequent worksheets to the first empty row on the first worksheet using the ‘Consolidate’ tool. The ‘Consolidate’ tool allows you to combine worksheets where data is defined by position or by category. In the workbook whose worksheets you want to consolidate, choose Data - Consolidate. Excel displays the Consolidate dialog box. You specify ranges by using the Reference box. Specify in the box the first range you want to consolidate. You can continue to define reference ranges until they are all complete.