How do i do this?

V

VSB

(Type)1 2 3 4
Add Type (1,2,3 etc) 0 36 60 300

Amount Paid
Date Paid
Renewal date

Comm Due
Comm paid Date Paid

Please can you help me with this. In box Add type, if i placed for example
type 2 that =36, i would like this amount to go automatically into Comm due.
It has been a long time since i have used excel. I hope this makes sense
Thank you
VSB
 
Top