Very new to VBA and trying to learn as much as i can on the fly. Need some serious help with this!

I have a file that pulls all the changes made during a certain period and sorts them based on date and what it is assigned too (budget, outlook03, outlook05, etc.) I would like to be able to automatically sum up the changes to get me a total for each assigned outlook. For example: I start at 100 there are 3 different changes (3 different rows) for Outlook02 the total would be 100+the 3 rows. Then i want to use that last total and add the next few changes to get the total for outlook03 and so on.

Below i have an example of my sheet. I need to automatically sum the starting budget number of 31 and all the outlook03 changes to get a total Outlook03. I then need to use that new total and add the changes of outlook07 to get the total of Outlook07 and so on. I need to do this for columns G to AX.

the number of changes in any given outlook will vary. I couldn't think of vba code that would work for this. Please help if this is at all possible.



a b c d e f g h i
Budget 31.0 35.0
Date Category Change Type Detailed Comments Assign Change to Step Jan-17 Feb-17
3/7/2017 Other/Timing AHT work Outlook03 1.0 1.0
3/15/2017 Lost Efficiencies Driver ok it has too Outlook03 1.0 1.0
3/29/2017 Efficiency Initiatives Frequency blank Outlook03 1.0 1.0
4/5/2017 Volume AWOP blank2 Outlook03 1.0 1.0
4/26/2017 Efficiency Initiatives AHT last one Outlook03 1.0 1.0
TOTAL OUTLOOK03
4/26/2017 Invest AHT gftrgsf Outlook07 3.0 4.0