Copying and auto updating a formula
I have a column AB (accum hours) on sheet I and it calculates a sum for
the previous 8 weeks (ie sheets A to H) which works fine, but when we copy
the formula on to the next week (sheet J) it stays the same when we need it
to calculate sheets B to I, and so on for the rest of the year, any ideas?
i know its probably simple
|