M
Mathew P Bennett
Fix Cell at End Of Each Month
Excel 2007
Good Evening Guys, another obscure question, help hoped.
I have a Summary SS which has months across columns.
A B
C
1 Aug 08 Sep 08
Oct 08
2 =[Ref1.xls]Sheet1!$A$1 =[Ref1.xls]Sheet1!$A$1
=[Ref1.xls]Sheet1!$A$1
As you can see, the same cell in the Ref1 w/s is referenced each month.
My question is, eg in A2, is there a way to automatically fix the value in
the cell (ie so it is no longer formulaic), once that month is over.
I hope I have explained this well enough.
Thank you
Mathew
Excel 2007
Good Evening Guys, another obscure question, help hoped.
I have a Summary SS which has months across columns.
A B
C
1 Aug 08 Sep 08
Oct 08
2 =[Ref1.xls]Sheet1!$A$1 =[Ref1.xls]Sheet1!$A$1
=[Ref1.xls]Sheet1!$A$1
As you can see, the same cell in the Ref1 w/s is referenced each month.
My question is, eg in A2, is there a way to automatically fix the value in
the cell (ie so it is no longer formulaic), once that month is over.
I hope I have explained this well enough.
Thank you
Mathew