if the most recent month column (C) will always be next to the most
recent month (column B), could just use =OFFSET(C2,0,-1), then when
you insert a new month in between june and the most recent it will
adjust to the new one

On Jul 1, 12:05*pm, Jennifer
wrote:
I have a sheet with all 12 months and then I have a column next to the total
column that displays the data from the newest month.

Ex.

May * * Jun * * | * | * * Total
1 * * * * *1 * * * * 1 * * * * *2
1 * * * * *2 * * * * 2 * * * * *3

The column that displays June's data again basically makes it easier for me
to look at and manipulate later.

Is there a way to automatically have that column update if I add data in a
July column?