How to automatic % calculation on the dollar amount

[geloader0]

Hi, Good day,

I need to set automatic % calculation on the dollar amount between amount of collection over the GPR right after the percent collection section. How to do it in formula and VBA? Thank you so much for your help