ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Update Field (https://www.excelbanter.com/excel-worksheet-functions/24522-update-field.html)

RG at UW

Update Field
 
I would like to add a date field that would only change if the spreadsheet is
updated, not just opened.

Thanks


Gord Dibben

RG

"Updated" means what?

Calculated or.....?

I think you want a Time Stamp that will change when a cell is changed but not
be volatile otherwise.

See JE McGimpsey's site for code.

http://www.mcgimpsey.com/excel/timestamp.html


Gord Dibben Excel MVP

On Mon, 2 May 2005 14:31:08 -0700, "RG at UW" <RG at
wrote:

I would like to add a date field that would only change if the spreadsheet is
updated, not just opened.

Thanks




All times are GMT +1. The time now is 08:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com