Pivot Tables????
 

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?


--
billy2willy
------------------------------------------------------------------------
billy2willy's Profile: http://www.excelforum.com/member.php...o&userid=21648
View this thread: http://www.excelforum.com/showthread...hreadid=376582

Give an example.
Ola


--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=376582