Updating last data entered in excel
In an Excel spreadsheet, I'd like to automatically update a cell with the current date and time when another cell is changed (like an update timestamp). I'd like to update them as soon as one of the preceding cells in the row is updated. Now, as long as auto-recalculate (the default) is set, any time another cell is changed, you'll get a fresh timestamp.
For example, if you discovered that there was an error in the order quantity, you could change it.
This feature has been added the Version 2 sample file, which has Add, Update, New and Delete buttons In this version, 3 named ranges were added: The New button runs a macro that clears the Data Entry Clear range, and puts the next available ID number in the IDNum cell.
Before updating the database record, the Update code checks to see of all the mandatory data entry cells are filled in.
Thirteen options exist for info_type and a discussion of each is beyond the scope of this short tip.
To see a detailed explanation of all thirteen info_type arguments, refer to Excel’s Help system.