Please solve this problem.

R

ramulu

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=89|
+-------------------------------------------------------------------+
 
M

Martin Fishlock

Hi Ramulu

Couple of ideas:

Copy the jan sheet to sheet2 and in sheet1!C7=C6-shee2!C6 and copy across

or insert a new row and record the jan figures on sheet1 (which you can hide
if you want to).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top