[Lamb Chop[_2_]]

is it possible to make a cell automatically update its data?


==================================
e.g.
sheet 1
some data that I enter daily.

sheet 2 which keep track of previous data.
column A = date
column B = the data from sheet 1

===================================
a detailed example:

sheet1:
A1="sell of today", B1= "volume"
A2= $1000, B2=4343


In sheet2,
A1="Date" B1="sell" C1="volume"
A2=15/06/2008 B2=$1434 C2= 3432
A3=16/06/2008 B3=$1000 C3= 4343 (suppose today is 16/06/2008)
....
....
....

=====================================

I have tried : in sheet2, column B and column C


B2=If(A2=today(),'Sheet1'!A2,"")
B3=If(A3=today(),'Sheet1'!A3,"")
.....
....
....

C2=If(A2=today(),'Sheet1'!B2,"")
C3=If(A3=today(),'Sheet1'!B3,"")

================

The problem I have is that all the cells in Sheet2, B and C change back to
"", which I would like to keep the yesterday data and previous data.

Any idea?

Thanks.