Summary Page Macro

[mjwillyone]

I would like to create an Excel workbook that helps me to produce th
yearly budget for our organization. Here is how I would like it t
work:

1. Tab #2 would use four columns. The columns are as follows:
A = Main Account Title
B = Sub-account title
C = Description
D = Yearly Cost

2. I would like the macro to pull the Main Account Title over to Ta
#1 Column A, then sum up all of the yearly cost amounts that appea
under the Main Account Title from tab #2 and drop this total ont
Column B of Tab #1.

3. This process is repeated for each Main Account Title found on Ta
#2.

As you can see, Tab #1 becomes a summary of all of the financia
breakdown from Tab #2. A macro that is always running in th
background would seem to work much better here than me having t
copy/paste each Main Account Title and the sum of its sub-accounts
especially when I need to make a change in the number of sub-accounts
have under any given Main Account Title.

Thank you very much,
Mik

 

[Jim Thomlinson]

This is easily accomlished using a pivot table. Your tab 2 which has 4
columns is ideal to Pivot. Select the range of data and Hit Data -> Pivot
Table -> and follow the wizard. Place A at the very top above the table.
Place B & C in the right hand columns and the amounts in the middle. Right
click on the A field at the very top and select view pages (This part assume
you are using Excel 2K or less. Off the top of my head I know you can do this
with 2002 and above but I do not remember exactly how).