Excel: How to consolidate data

Excel consolidate: Consolidating data


Excel consolitadate: YOUR OBJECTIVE

In an Excel workbook, you created three worksheets that contain your company’s first-quarter sales figures for as many business locations. To maintain a clear overview, you recorded the sales numbers for each business location in a separate table, on a separate worksheet. That is, there is a worksheet for Berlin, another for Frankfurt and a third for Munich. The tables are in different positions on each worksheet; some contain different ice cream flavors. [Read more...]