Inserting Columns and Formulas updating
 

I have a column setup for each month with formulas in them linking to other
tabs in the spreadsheets. On the main spreadsheet that brings together all
the tabs, how do you insert a column each month with the most recent month
being first and the other months formulas updating once I insert a column
(i.e. Column D - Feb. 2005 =Sum('Sheet 1:Sheet 26'!d15), Column E Jan. 2005
=sum('Sheet1:sheet26'!e15)- for March I would like to insert it before D and
have the Feb. and Jan. columns update in formulas (Feb to !e15 and Jan !f15)
for the new inserted column(March !d15).

Instead of creating a column each month, create a Master with all the columns
you will need. Hide the unneeded (future) columns.
HTH,
--
Gary Brown



"Jaime Balance Sheet" wrote:

I have a column setup for each month with formulas in them linking to other
tabs in the spreadsheets. On the main spreadsheet that brings together all
the tabs, how do you insert a column each month with the most recent month
being first and the other months formulas updating once I insert a column
(i.e. Column D - Feb. 2005 =Sum('Sheet 1:Sheet 26'!d15), Column E Jan. 2005
=sum('Sheet1:sheet26'!e15)- for March I would like to insert it before D and
have the Feb. and Jan. columns update in formulas (Feb to !e15 and Jan !f15)
for the new inserted column(March !d15).