autoupdate data?

[Lamb Chop]

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.

 

[Max]

Why not just set it up for simple data entry directly in Sheet1 with 3 cols
(Date, Sell, Volume)? You could then easily use autofilter on the same sheet
to see all the sales volume for any particular date, and create a pivot table
to drive out various summaries (sales by date, etc) easily in another sheet.

 

[Max]

Now, whether that response appeals to you or not, you should always post
back with your comments (this is a discussion group, remember). Other
responders could step in to offer you other ideas, depending on how the
discussion progresses, etc. Keeping silent doesn't serve any purpose.

 

[Lamb Chop]

Thanks you first, Max for your prompt reply. I was checking autofilter and
pivot table from the help to see if it is the key. I just want to
understand it before I reply. Unfortunately, autofilter and pivot are not
ones I need.

However, I found a new way to fix my problem which you may interested.
I created a csv file where I input the data. Then in excel under Data,get
external data and import text file, I can make it automatically update the
data every 5 minutes. For me, it is quite a new technique.

thanks again for your sharing, Max.

Choppy

 

[Max]

No prob, thanks for posting back