software

I have to regularly update a spreadsheet with stock prices but can
only do a certain number per day. I therefore need to see the last
time I updated any cell.

I would like to automatically generate an absolute date in the next
column cell showing the date the modification was made. I have looked
at functions such as TODAY() but these will automatically update
whenever I open the worksheet - which I don't want.

Is this possible in excel amp; ideally without using a macro?Check out

www.mcgimpsey.com/excel/timestamp.html

In article . comgt;,
quot;nickquot; gt; wrote:

gt; I have to regularly update a spreadsheet with stock prices but can
gt; only do a certain number per day. I therefore need to see the last
gt; time I updated any cell.
gt;
gt; I would like to automatically generate an absolute date in the next
gt; column cell showing the date the modification was made. I have looked
gt; at functions such as TODAY() but these will automatically update
gt; whenever I open the worksheet - which I don't want.
gt;
gt; Is this possible in excel amp; ideally without using a macro?

nick wrote:
gt; I have to regularly update a spreadsheet with stock prices but can
gt; only do a certain number per day. I therefore need to see the last
gt; time I updated any cell.
gt;
gt; I would like to automatically generate an absolute date in the next
gt; column cell showing the date the modification was made. I have looked
gt; at functions such as TODAY() but these will automatically update
gt; whenever I open the worksheet - which I don't want.
gt;
gt; Is this possible in excel amp; ideally without using a macro?
gt;
If you are using the MSN Quote add-in, one of the parameters you can
download is the date amp; time) of the last trade.

ron