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

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
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
203 Replies