autoupdate data?

  • Thread starter Thread starter Lamb Chop
  • Start date Start date
L

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.
 
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.
 
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.

---
 
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
 
Back
Top