Hello -- First time posting here. I need some help to hopefully make my
workflow more automated. I work with a number of fairly simple files on a
daily basis. A few of these files have all the dates of the month down one
column, and running data going down another column. I manually update data
from another spreadsheet, which does not have running data for the month,
only detailed information for the day

Example 1 (which I manually update):
Date Stock Price
4/01/07 10.00
4/02/07 10.02
4/03/07 9.40
4/04/07 <blank cell
4/05/07 <Blank cell
etc



Example 2 (Detailed information for the day. which we overwrite on a daily
basis. The Stock price is taken from a web query)
Today's stock price is: 9:40


I work with 5 spreadsheets that have this kind of running date that is
updated on a daily basis manally (some are sums of different cells, some can
be referenced to just one cell), and I can't think of an automated way to
make this work.
How do I update my Month's report by linking they two spreadsheets?

Is there some kind of conditional formatting that will only update the cell
for the day, and if not the day don't do anything?

I have tried " =if(A1=today(),A2) where A1 is the cells with the date, and
A2 is the data I need. If I drag this formula through the column, it makes
all, but today's date have no data. If you have any ideas please let me know.

I hope what I want to do makes sense!