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

[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
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Lamb Chop" wrote:
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]

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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

[Lamb Chop[_2_]]

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" wrote in message
...
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
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Lamb Chop" wrote:
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]

No prob, thanks for posting back
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Lamb Chop" wrote in message
...
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