I have attached a spreadsheet that has two tabs [Example 1 and Example 2] Example 1 contains two months data Example 2 contains 3 months data.
In Column B there is the word Total and in their respective row are totals.
C5 is =SUM(C3:C4)
D5 is =SUM(D3:D4)
E5 is =SUM(E3:E4)
Under I-K are the totals of the totals:
I5 is =C5+F5
J5 is =D5+G5
K5 is =E5+H5
So this is where it gets tricky.
Example 2 shows 3 months data.
What I am trying to do, without success is each month 3 new columns will go into the right hand side after the previous month. So looking at Example 2 columns L-N will move to O-Q and 2014/ Apr data would go into L-N
When the new months are input I need all of the formula to auto-populate [preferably using VBA code because this is part of a bigger Macro]
This sounds like an impossible request but I know there is an expert out there that likes a challenge like this.
thanks in advance.