In the same Consolidate dialog window, select any of the following options: If one or some of the sheets reside in another workbook, click the Browse bottom to locate the workbook. Then click the Add button to have that range added to the All references Repeat this step for all the ranges you want to consolidate. In the Reference box, clicking the Collapse Dialog icon and select the range on the first worksheet.In the Function box, select one of the summary functions you want to use to consolidate your data (Count, Average, Max, Min, etc.).The Consolidate dialog windows appears and you do the following: If your master worksheet already has some data, make sure there is enough space (blank rows and columns) to contain the merged data. It's is advisable to consolidate data into an empty sheet. In the master worksheet, click the upper-left cell where you want the consolidated data to appear, go to the Data tab and click Consolidate. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |