I have an excel sheet that I update every week. Each week a new column is added to the sheet, and each row has a formula that tallies up the total over these columns
for example in the Y column I have:
For row 7 formula is =SUM(D7:X7)
For row 8 formula is =SUM(D8:X8)
so on , so forth
I have 50 rows that I have to update the formula if i add another column. So if last week the formula was in Column Y, this week its in Column Z so the new formula looks like
=SUM(D7:Y7)
=SUM(D8:Y8)
How do I do this more efficiently, by just changing one row's formula and apply it to the other rows?
2006-12-08
05:37:24
·
5 answers
·
asked by
arus.geo
7