hi everybody,

I am having a problem where the cell value is changing every month, but I want to know the January value of a cell, in any month.

file is attached

Thanks.

If you put the January value in a hidden cell then you can always refer to
that cell to know what the January value was.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"ramulu" wrote in message
...

hi everybody,

I am having a problem where the cell value is changing every month, but
I want to know the January value of a cell, in any month.

file is attached

Thanks.


+-------------------------------------------------------------------+
|Filename: book.zip |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=88|
+-------------------------------------------------------------------+



--
ramulu