How do i do this?
 

(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

How do i do this?
 

You need to give more info.
Columns and Rows might help

"VSB" wrote:

(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