Link to home
Start Free TrialLog in
Avatar of Ehonwollen
EhonwollenFlag for United States of America

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
ASKER CERTIFIED SOLUTION
Avatar of Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Ehonwollen

ASKER

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
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
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