•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Pull the value of a cell at a given time
Our take
If you want to track the value of a specific calculation over time in your spreadsheet, recording its value daily at midnight is a great approach. Instead of redoing the calculation with a subset of responses—which can slow down your workflow—consider using a script or automation tool that captures and logs the value at the desired time. This method will ensure you maintain performance while effectively monitoring changes in your data. Let’s explore some solutions that can streamline this process for you.
I have a sheet that populates from a Microsoft Form and a statistics sheet that does some calculations based on the responses. I would like to track the value of one of the calculations over time by recording its value every day at midnight but I don’t know how to go about that. I thought about redoing the calculation with only the subset of responses before the specified date but it ends up being very slow
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#rows.com#real-time data collaboration#real-time collaboration#Excel compatibility#cloud-based spreadsheet applications#Excel alternatives for data analysis#financial modeling with spreadsheets#Excel alternatives#Microsoft Form#track value#statistics sheet#calculations#value over time#responses#recording value#data tracking#specified date#subset of responses#excel#midnight