I need the help of all you experts out there. I have the following formula
throughout my spreadsheet.

=IF(INDEX(Summary!I$3:I$80,MATCH(VendorCommodities _Detail!$C3,Summary!$C$3:$C$80,0))="","",INDEX(Sum mary!$I$3:$I$80,MATCH(VendorCommodities_Detail!$C3 ,Summary!$C$3:$C$80,0)))

Basically, Column I on sheet2 pulls its data from column I on sheet1 and in
a seperate but similar formula, column L on sheet2 pulls its data from column
J on sheet1. With the exception of rows throughout the columns that give
totals, averages etc (these rows are protected)

Now I want to add a new column into sheet1 (for a new months data) and have
the formulas reference that column instead. But, due to the various rows of
protected totals, I cannot use the autofill option to change all of the
formulas in the column at once. Right now I pretty much have to manually
chnage the formulas in each cell (some are in bunches of 5-10 rows, but still
very time consuming)

Surely there is an easier way to go about this. Any ideas?

thanks
diane