Home

"Freeze" results of a cell formula

%3CLINGO-SUB%20id%3D%22lingo-sub-550328%22%20slang%3D%22en-US%22%3E%22Freeze%22%20results%20of%20a%20cell%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-550328%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20excel%20spreadsheet%20used%20to%20keep%20a%20log%20of%20a%20system's%20behavior.%20A%20cell%20in%20each%20log%20entry%20depends%20on%20a%20configuration%20variable%20that%20can%20be%20changed%20as%20time%20(days)%20go%20by.%20I%20would%20like%20each%20log%20entry%20to%20record%20the%20setting%20of%20that%20variable%20at%20the%20time%20the%20log%20entry%20was%20created.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20put%20a%20formula%20in%20once%20cell%20of%20the%20log%20entry%20that%20captures%20the%20variable%2C%20and%20does%20not%20change%20as%20new%20log%20entries%20are%20made%3F%20The%20log%20table%20grows%20one%20row%20at%20a%20time.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20I%20could%20do%20this%20programmatically%20with%20a%20macro%20but%20would%20prefer%20a%20non-macro%20solution.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20I%20have%20expressed%20that%20clearly!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-550328%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-553560%22%20slang%3D%22en-US%22%3ERe%3A%20%22Freeze%22%20results%20of%20a%20cell%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-553560%22%20slang%3D%22en-US%22%3E%3CP%3EI%20think%20I%20can%20state%20this%20more%20clearly...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20I%20cause%20a%20cell%20with%20a%20formula%20to%20replace%20it's%20formula%20with%20the%20value%20resulting%20from%20the%20formula%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20know%20I%20can%20cut%20and%20paste%20to%20make%20that%20happen%20but%20I%20don't%20want%20to%20go%20through%20those%20steps%20as%20they%20are%20error%20prone%20or%20easily%20skipped%20by%20mistake.%20Ideally%20it%20would%20happen%20automatically%2C%20perhaps%20as%20the%20date%20changes.%20Old%20entries%20would%20be%20frozen.%3C%2FP%3E%3C%2FLINGO-BODY%3E
bertilak
New Contributor

I have an excel spreadsheet used to keep a log of a system's behavior. A cell in each log entry depends on a configuration variable that can be changed as time (days) go by. I would like each log entry to record the setting of that variable at the time the log entry was created.

 

Is there a way to put a formula in once cell of the log entry that captures the variable, and does not change as new log entries are made? The log table grows one row at a time. 

 

I think I could do this programmatically with a macro but would prefer a non-macro solution.

 

I hope I have expressed that clearly!

1 Reply
Highlighted

I think I can state this more clearly...

 

Can I cause a cell with a formula to replace it's formula with the value resulting from the formula?

 

I know I can cut and paste to make that happen but I don't want to go through those steps as they are error prone or easily skipped by mistake. Ideally it would happen automatically, perhaps as the date changes. Old entries would be frozen.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
48 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies