cell populated with a 'Date Stamp' ' based off of a different cell being manually or by a formula populated.
I need to have a cell populated with a 'Date Stamp' ' based off of a different cell or cells being manually updated or by a formula populated.
The worksheet has several cells in row that data can be place in some cells and other cells information formulated as a result data being inputted on the worksheet or work book. Our goal is have ability date stamp any changes made in a cell whether manual calculated and record and save that date stamp until data is changed
That did not accomplish what we trying to do . So, I provided a sample Excel layout to show what we need. The timestamp should only changes when one or more of the 6 cells change and the timestamp should not change when opening or closing the workbook. SAMPLE-.xlsx
Teylyn
Thanks for your patience..The macro reads the cells and generates the timestamp only if the data in the cells monitored are changed by a direct data entry (i.e., the keyboard). I need the macro to be triggered when the cell value changes as a result of a reference to another cell that has changed on another sheet: (i.e., Cell H1 on Sheet2 has the formula ” =INDIRECT("'Sheet1'!$A$2") ”). Is that possible
Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Ehonwollen,
that's a whole different setup. I'm not a VBA Genius, but I doubt it can be done. There's just too little that Excel can go on to recognise if something has changed. See, if you have a formula in a cell and the precendents change, the actual cell does not change. It's just that the formula is being recalculated. There is no watch event that I'm aware of that can monitor the results of recalculation and whether or not it turns out a different result than before.