Update cell on most recent change

[Anarchus]

Hi there,

I have three cells that will always have data change in it, I would like a fourth cell to show the most recently updated cell.

I assume if would be some kind of "IF" statement but I'm not sure how to write it.

The cells with the data are O34, O35, O36. I want the formula to go into cell O38. If O34 is updated, I want cell O38 to show this number, then if O35 is updated, O38 will change from showing the value in O34 and show the value of O35 now, and so on.

Thank you

[JBeaucaire]

There is no formula that would do that. That would require some sort of VBA program running on that sheet at all times watching those cells. Do you use VBA in your projects? Not everyone can or will allow executables in their Excel.

[Logit]

Here's a shorter version of the other posting in the other thread:

Please Login or Register  to view this content.

[Trebor76]

Here's a shorter version of the other posting in the other thread

Yes but not turning off events will make the code run again when cell O38 is updated. Not turning off screen updating with one cell is fair enough.

[Anarchus]

Hi Logit,

Thanks for your code, it works, with one slight exception. The only way it will update is if I click on the cell and press "Enter". The cells are taking there volumes from another sheet, is there a way to make the code automatically update as soon as the value changes without the need to press enter?

[Logit]

Use this syntax:

Please Login or Register  to view this content.

[Anarchus]

Thanks Logit!

[Logit]

Your welcome. Merry Christmas !