G Guest May 2, 2005 #1 I would like to add a date field that would only change if the spreadsheet is updated, not just opened. Thanks
I would like to add a date field that would only change if the spreadsheet is updated, not just opened. Thanks
G Gord Dibben May 2, 2005 #2 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
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