Following is an excerpt from a checkbook. I'm on another worksheet or in another workbook, and would like the last value in the checkbook automatically updated. For ex, if I'm on a different worksheet and it's Sept 9th, I would want 37,086.67 to show w/out having to go get it. If I'm on that worksheet today, I would want that cell to read 36,778.24. There is a new line and updated balance every time a transaction is posted. Thank you
[TABLE="width: 173"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD="align: right"]38,217.41[/TD]
[TD="align: right"]9/9/2019[/TD]
[/TR]
[TR]
[TD="align: right"]38,079.54[/TD]
[TD="align: right"]9/9/2019[/TD]
[/TR]
[TR]
[TD="align: right"]37,921.09[/TD]
[TD="align: right"]9/9/2019[/TD]
[/TR]
[TR]
[TD="align: right"]37,674.78[/TD]
[TD="align: right"]9/9/2019[/TD]
[/TR]
[TR]
[TD="align: right"]37,411.32[/TD]
[TD="align: right"]9/9/2019[/TD]
[/TR]
[TR]
[TD="align: right"]37,086.67[/TD]
[TD="align: right"]9/9/2019[/TD]
[/TR]
[TR]
[TD="align: right"]35,377.24[/TD]
[TD="align: right"]9/10/2019[/TD]
[/TR]
[TR]
[TD="align: right"]36,355.15[/TD]
[TD="align: right"]9/11/2019[/TD]
[/TR]
[TR]
[TD="align: right"]36,778.24[/TD]
[TD="align: right"]9/11/2019[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 173"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD="align: right"]38,217.41[/TD]
[TD="align: right"]9/9/2019[/TD]
[/TR]
[TR]
[TD="align: right"]38,079.54[/TD]
[TD="align: right"]9/9/2019[/TD]
[/TR]
[TR]
[TD="align: right"]37,921.09[/TD]
[TD="align: right"]9/9/2019[/TD]
[/TR]
[TR]
[TD="align: right"]37,674.78[/TD]
[TD="align: right"]9/9/2019[/TD]
[/TR]
[TR]
[TD="align: right"]37,411.32[/TD]
[TD="align: right"]9/9/2019[/TD]
[/TR]
[TR]
[TD="align: right"]37,086.67[/TD]
[TD="align: right"]9/9/2019[/TD]
[/TR]
[TR]
[TD="align: right"]35,377.24[/TD]
[TD="align: right"]9/10/2019[/TD]
[/TR]
[TR]
[TD="align: right"]36,355.15[/TD]
[TD="align: right"]9/11/2019[/TD]
[/TR]
[TR]
[TD="align: right"]36,778.24[/TD]
[TD="align: right"]9/11/2019[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]