@Shaun Gorneau and @Carl Thank you very much for your help.
So it looks like I'm going to have to go with the recalculating option then.
I just wanted to make sure there isn't another more obvious way to do this before I jump down the rabbit hole.
I will see what I can come up with and then come back with my solution in case it helps anyone, or if anyone can point out improvements.