Johnny c, Thanks for the fantastic additional comments.
You described a real world scenario that will resonate with a lot of accounting and finance folks, for sure, and is far more common than many companies realize.
You should share the VBA that you developed — I’m sure there are more than a few who would want to put it to the test!
Appreciate the insight!