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

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

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" <(E-Mail Removed)> wrote in message
news:9FC8BBC4-1244-46BF-A758-(E-Mail Removed)...
> 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.
>>
>>
>>
>>

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