I want a formula to use data from a fixed location. For example I am using a
table B2 to I4.
During the week new value are added to the right of this table and then the
table is shifted to the left. So a value in I4 becomes G4 etc. I want the
formula to continue using I4 despite the fact it has been shifted but the
formula automatically adjusts to read G4.
IN SHORT Is there anyway to fix the formula to read a fixed physical
location and not track the position of the cells?
I know how to fix the value when the formula is moved(using $), but not how
to fix the source for the formula.
Anyone know a way
Thanks
Pete