Forum Discussion

andrew165's avatar
andrew165
Copper Contributor
Dec 12, 2020

Excel Auto Updates Stop Limit

I am sure there is already an answer out there on the forum for this but I am not sure what key words I am missing to find it.   I am working on a Stock Tracker that uses lives updates for my "home...
excel
Formulas and Functions
andrew165's avatar
andrew165
Copper Contributor
Dec 13, 2020

I found the answer, it will be a VBA to calculate only once across the cell based on the variables.  though I'm not too sure how to it to edit it to meet my requirements.  Link is below.

 

https://superuser.com/questions/450019/how-to-have-a-cell-calculate-only-once

 

I have many sheets in my workbook, the first being my dashboard which holds all of my calculations and my live updates and I'm using my second sheet "December 2020" to work out the kinks prior to the new year.

 

In cell 'Dashboard!I10' I have my calculation running for my daily gain % which updates based off the live inputs in other cells.  Cell 'December 2020!B15' is the desired cell to be updated when the date and time parameters are met (i.e. December 14th 2020 at 4:00 PM EST) and retain the value given at the end of the day.  While the next day cell 'Dashboard!I10' continues to update but instead it reflects in cell 'December 2020!B16' and so on.

 

 

 

Resources