Formula depending on date

[Temp]

How can data from one cell, content a formula depending on date,
REMAIN (in some other cell), if date is changed. I need this to
collect data from daily report to a monthly report, day by day...
Tanks

 

[Max]

Ok, guess you're looking for a way to freeze the values
returned by formulas in your daily report sheet?

Try this to do it for entire sheets:

(a) In your "daily report" worksheet, say Sheet1
----------------------------------------------------
Press Ctrl + A
(this selects the entire sheet)

Click Copy

(b) In another new (empty) sheet, say Sheet2
-------------------------------------------------
Right-click on A1 > Paste special > Check "Values" under Paste > OK

And if you want to copy over the format from Sheet1 to Sheet2 as well,
just repeat the step above but select "Formats" instead of "Values", i.e.:

Right-click on A1 > Paste special > Check "Formats" under Paste > OK
-----------------------------------------------

Sheet2 will be an "exact replica" of Sheet1, but devoid of formulas

Repeat step (a) the next day to freeze Sheet1 again to say a new Sheet3,
and so on

Sheet2, Sheet3, etc will hence be your "daily reports"
which you can then summarize / use to compile your monthly report

 

[Max]

Came across your earlier post in .misc
Subject: Problem with formula depending on date.
which is related to this one.

I've given you a reply in that thread
(reply pasted below)

You need a macro to transfer the values
from sheet: Daily report to sheet: Monthly