Thursday, November 22, 2012

How to gets the total value from other tab into summary tab in excel

Are you having problem to get the summary review for the 'Total from other month' ? Like in the snapshot below.



So the step are:-
1) Click on the selected box you want the 'Total from Report January'

2) Under Data, click on Consolidate button

3) Consolidate will be opened. Select Function: 'Product'

4) Click on icon next to 'Browse' under Reference. Window like below will be displayed

5) Click on 'Report January' then click on 'Total Value'

6) Click on previous icon. Then the window will be displayed like below. 

7) Click on 'Add' button and tick on 'Create links to source data' checkbox.

8) View on Summary tab, Price value on 'January' column is same as in 'Report January'

9) Try change the value price at 'Report January'. The Price value on Summary tab will be updates.
     Example. From 100 to 150. New total will be 238.



No comments:

Post a Comment

Note: Only a member of this blog may post a comment.