Automatically freeze data after running new formula

[KIM Chanthan]

Dear sir,

Do you have any way to keep data which come from formula still the same (like past value). And it will not involve with that fomular any more.
Suppose I don't want to anything on it second time.
Please see attachment for detail.

Thank,
Chanthan

 

[Luke M]

In short, no. You'll want to either be doing a copy, paste value every time. Or, since you're already manually changing something, just type the date into the correct cell. Final option is to have a macro insert the date stamp, such as:

Sub Example()
'Puts today's date in next blank cell in col E
Cells(Rows.Count, "E").End(xlUp).Offset(1).Value = Date
End sub

 

[KIM Chanthan]

In short, no. You'll want to either be doing a copy, paste value every time. Or, since you're already manually changing something, just type the date into the correct cell. Final option is to have a macro insert the date stamp, such as:

Sub Example()
'Puts today's date in next blank cell in col E
Cells(Rows.Count, "E").End(xlUp).Offset(1).Value = Date
End sub

Thank anyways for your reply.