| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fix Cell Data at End of Each Month
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 month to month data change grid | Excel Discussion (Misc queries) | |||
| Retrieve data for previous 3, 6, 12 month given current month | Excel Worksheet Functions | |||
| When using MONTH function on Blank Cell!! Returns Month=Jan! | Excel Discussion (Misc queries) | |||
| Compare month to month data | Excel Worksheet Functions | |||
| transfer cell $ amount to other sheet month-to-month without overc | Excel Discussion (Misc queries) | |||
Threaded Mode
