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

--
mjwillyon

Excel novice - but learning
-----------------------------------------------------------------------
mjwillyone's Profile: http://www.excelforum.com/member.php...nfo&userid=311
View this thread: http://www.excelforum.com/showthread.php?threadid=39591