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.