Avatar of Ehonwollen
Ehonwollen
Flag 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
Microsoft Excel

Avatar of undefined
Last Comment
Ingeborg Hawighorst (Microsoft MVP / EE MVE)

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Ingeborg Hawighorst (Microsoft MVP / EE MVE)

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.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
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
Ingeborg Hawighorst (Microsoft MVP / EE MVE)

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.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Ehonwollen

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") ”).  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.

So, no, I don't think it's possible, sorry.

regards, teylyn
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck