Generate an Absolute Date in a Cell
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 & ideally without using a macro? |
Generate an Absolute Date in a Cell
Check out
http://www.mcgimpsey.com/excel/timestamp.html In article . com, "nick" wrote: 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 & ideally without using a macro? |
Generate an Absolute Date in a Cell
nick wrote:
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 & ideally without using a macro? If you are using the MSN Quote add-in, one of the parameters you can download is the date & time) of the last trade. ron |
All times are GMT +1. The time now is 12:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com