By Hamid Bloem at May 15 2019 18:10:00
Using the Consolidation feature. You can determine whether or not the link will be interactive when creating the consolidation. This method provides the greatest level of detail in the summary worksheet. You can choose between any function, not just the sum function. For example, you could create an average of several divisions in a summary worksheet. Some of the disadvantages of this method are that the worksheets must be identical. Although it is not impossible, it is difficult to use consolidation across workbooks.
Once you put your numbers in, how do you compare to the national average or some other standard guideline? The budgeting worksheet should give you some idea of how you compare in each of the above categories. Then you can make some decisions if you're over or under spending in some areas. The beauty of using worksheets is not only to see where your money is going but to see how you compare to a standard guideline.