asked on 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
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
Microsoft Excel
Last Comment
Ingeborg Hawighorst (Microsoft MVP / EE MVE)
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
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")
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")
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.
So, no, I don't think it's possible, sorry.
regards, teylyn
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.
So, no, I don't think it's possible, sorry.
regards, teylyn
SAMPLE-.xlsx