Pivot Tables????

B

billy2willy

Lets say on your spreadsheets you have 5 different units, some using
common charge groups, some using uncommon chargegroups, all with a
actual spending, budgeted spending and a variance from each related
chargegroup.

Is there a way you can have a summary sheet that finds each charge
group and adds up the total from the 5 units and spits out the
chargegroups with the actual spending, budget and variance rolled up.

What would be the best way of doing this?
 
Top