last updated

I'm looking to populate a field with the last date a row was updated. Currently, I have data in columns A - J and if any of those are updated for a given row, I would like column K of that row to be updated with that date. (I'm fine with date and time as well if that is easier). This is a...

Hello, I am wondering if there is a simple Excel Worksheet Function (or less ideally, a custom VBA-defined Function) which can automatically return the date last modified, i.e., when the document was last updated/modified, recalculated and/or saved? Thanks for any tips. K.

I am trying to make a column (Column AM) in an excel spreadsheet that automatically populates "Last Updated" only when any info within that row is updated (not the whole sheet). The code I have in VBA populates a single cell, but I can't drag it down to fill in the rest. I would like to...

Dear all, In a previous post on this forum a formula for creating a "last updated" cell for a certain range of cells is given. For instance, if cells A1 till A3 change, A4 will display: Last updated on: 22-6-2012. I've changed the formule (in MVB) myself into the range I need. B3 till BZ3...

Hello all! I am wondering if there is a non-VBA way to have a cell in a worksheet display the last time that worksheet was updated/modified (or maybe last time it was saved?). I know how to do this using VBA, but was wondering if there was a built-in function or some way of using the NOW...

I am using Excel 2007. I have a workbook with several sheets showing time sheets. Is it possible to have a cell in the sheet, the value of which changes to the last updated date as soon as somebody edits the sheet. Thanks JK