The attached sheets require an =sumproduct (I think) to look up data and combine all instances of the totals from the CM Original Budget vs Actual 2013 file commencing from column AA and placing in the corresponding cells in the Division Updates budget vs Actual.
I have used a raw = format however that will not pick up any additional lines added into the datafile when/if they are added, so I'm hoping a sumproduct will work.
thanks in anticipation.
Bookmarks