|Tenant Name||Recovery Restrictions (Drop Down List)||Amount||Total Budget||Max Recovery||Annual Charge To Tenant||Annul Charge To Landlord||Quartely Tenant||Qaurterly Landlord|
|Tenant A||E.g Void||100||100||£100||£25|
|Tenant B||E.g Rent inclusive||200||200||£200||£50|
|Tenant C ||None||300||300||£300||£75|
My table looks like the above. So what I want is to be able to select each of the drop down list options (they will be the same for all col B) and for this to have the following result:
Void - insert the Total Budget Figure (£100) into the Annual Charge to Landlord cell and then in the Quarterly cell show the amount reflecting 25% I,e 25.
Rent inclusive - the same as void above.
None - as per void above but this time populating the Annual Charge to Tenant cell and then the Quarterly figure.
Cap/Lease Defect - no action required.
I have shown as an example in the table how the above would look.
Hope you can help.