Update cell value if the value in another cell is changed in a date range

[Johno1974]

Hello,

I would like to use Excel formulas to keep a record of when a cell is updated by a user. Let's say the cell the user might update is Cell A1.
I want Excel to do this:
The value in Cell A2 becomes the value in Cell A1 if a user updates the value in Cell A1 in June 2024.
The value in Cell A3 becomes the value in Cell A1 if a user updates the value in Cell A1 in July 2024.
The value in Cell A4 becomes the value in Cell A1 if a user updates the value in Cell A1 in August 2024.
and so on...

Is this possible please?

Thanks in advance.

Johno

 

[Joe4]

Welcome to the Board!

I don't think you are going to be able to do this with formulas. I think this is going to require VBA.
Are you OK with that?

 

[Johno1974]

Welcome to the Board!

I don't think you are going to be able to do this with formulas. I think this is going to require VBA.
Are you OK with that?

Hi Joe. Unfortunately I'm not permitted to use VBA in this particular application. Which is frustrating! So I need to use formulas if possible...

 

[Joe4]

Automation = VBA!

The issue with formulas is that you can either have formulas, or hard-coded values in a cell, but never both at the same time.
So you cannot "lock" your value entries in, without manual intervention.

If you re-design your sheet/methodology, perhaps you might be able to do something, though I think you would need different cells for each entry (instead of entering into cell A1 every time).
You can read this here, which contains a link of how to do Datestamps without using VBA. I have never used that method myself, but perhaps it will give you some ideas.

Timestamp without VBA

I have a worksheet that needs a timestamp in the cell in the next column to the entry cell - Column N has the cell that requires an entry and Column O has the timestamp (MMM/DD/YYYY H:M:S). That timestamp can't change unless someone updates the cell in Column N, then it gets the new timestamp...

www.mrexcel.com

 

[Johno1974]

Automation = VBA!

The issue with formulas is that you can either have formulas, or hard-coded values in a cell, but never both at the same time.
So you cannot "lock" your value entries in, without manual intervention.

If you re-design your sheet/methodology, perhaps you might be able to do something, though I think you would need different cells for each entry (instead of entering into cell A1 every time).
You can read this here, which contains a link of how to do Datestamps without using VBA. I have never used that method myself, but perhaps it will give you some ideas.

Timestamp without VBA

I have a worksheet that needs a timestamp in the cell in the next column to the entry cell - Column N has the cell that requires an entry and Column O has the timestamp (MMM/DD/YYYY H:M:S). That timestamp can't change unless someone updates the cell in Column N, then it gets the new timestamp...

www.mrexcel.com

Okay, understood. Many thanks for your support, Joel. Much appreciated. Kind regards, Johno

 

[Johno1974]

Okay, understood. Many thanks for your support, Joel. Much appreciated. Kind regards, Johno

Sorry, I meant Joe, not Joel

 

[Joe4]

You are welcome.