Consolidation
Helps to consolidate the different worksheets data. Whenever there is update on the individual sheet tabs, we can update that sheet tab to consolidated sheet with this trick.
Step 1: Created sales sheet tab for Jan, Feb with Data - Click on Consolidate button from Data tab or menu. Select the range of data from reference and then click on add. (Repeat for all sets of data Example: Jan Sales, Feb Sales)
Step 2: Click the check box Top Row and Left column, then click OK. So that we can publish the consolidated data where ever we needed
Note: If you click the check box "Create links to sources data" will help us to show the result along with formula links. With Browse option we can select and add from external excel files as well.
Helps to consolidate the different worksheets data. Whenever there is update on the individual sheet tabs, we can update that sheet tab to consolidated sheet with this trick.
Step 1: Created sales sheet tab for Jan, Feb with Data - Click on Consolidate button from Data tab or menu. Select the range of data from reference and then click on add. (Repeat for all sets of data Example: Jan Sales, Feb Sales)
Step 2: Click the check box Top Row and Left column, then click OK. So that we can publish the consolidated data where ever we needed
Note: If you click the check box "Create links to sources data" will help us to show the result along with formula links. With Browse option we can select and add from external excel files as well.
Comments
Post a Comment