I am trying to create an Excel VBA Macro that will calculate vacation time accrual.
Basically, I would like to run the macro to update the available PTO by calculating: Accrued Balance = (Carried Forward + Accrued + Hrs this Period) - Used PTO.
The problem is that I need to update the Accrued Balance when the calculation is complete. This gives me a circular ref error.
I tried calculating the value to a new cell and then update the old value to complete the tasks.
It is almost like this has to be multi sub tasks in the macro. Just not sure how to do this.