How to Auto save Date formula in excel

[malekari]

Hi team,

I am looking for a formula/vba where the 'change date' is formulated to =Today() date and 'changes updated by' which is basically the name - is either picked up from an individual's desktop or from the last modified Info. However, these details i.e., the date and the name is later freeze when the excel is closed. Does anyone think that we could have a fix for this?

Below is the excel format:

Thanks again!

Regards,
Ivan

 

[Joe4]

In Excel VBA, there are "event procedures", in which VBA code is automatically triggered upon some event happening, such as:
- the opening of a workbook
- the selection of a cell
- the manual updating of a cell
- a recalculation happening
- the saving of a workbook
and many others.

What is very common to do with Excel VBA is to add a "Date Stamp" to a certain cell by automatically populating it with the current date (not a formula, but the actual date) when another cell is updated.
(If you do a search on "Excel VBA Date Stamp", you will finds thousands of threads on this topic as this question is asked quite often).

Does something like that sound like it will work for you?
If so, we need to know a few things, such as:
- what cell/column are we monitoring for a change in value
- what cell/column the date stamp will go into
- what cell/column the username will go into