comparing data from different sheets

Hello VBA fans,

i´ve got differnt Kind of contracts, with different kind of running time.

In this table i have the year and the costs.

For example.

Year/Costs
2010/10
2011/600
2012/1500
2013/3000
2014
2015
2016
2018
2019

The costs for 2014 - 2019 are not know yet.

Now i have 6 different kind of contracts. The contracts have several running time´s.


Now i want to calculate the expecting costs of the contract.


For each contract with a several running time, i´ve created percentages, in several Sheets.

So for example, if a contract runs 8 years, after 4 years, 19% of the total costs have allready arisen.

With this i want to calculate the expected costs.

This would be then 3000€ (year 4) / 19 (percentage of the total costs in year 4, by a running time of 8 years) * 100.

Then i have the expected costs.


It something likes this possible?

I really have not so much clue how to do that.

Help, please!


I put a file in the Appendix.

Here are further informations.

greetz benjamin

Thank´s a lot.

This is exactly what i was looking for.

greetz benjamin