SALAM
HI Everone i have data on the difference variables from 1984 to 2009 for 84 countries.
some of the values are missing for some variables.
I want to fill in these last missing values for each country.

like for country Albania fill in the last missing values from 2005 to 2009. the point is that only fillin the last missing values not the starting missing values. like if for any country values are missing from 1984 to 1989 donot fill these values.

Now what is the formula to fill in these missing values.

First of all i have to calulate the growth of last five values(non-missing). than using this growth rate , i have to fill in the next missing values.


Note 1: plz make the code flexible i-e before runing the code it asks for how many values you want to calculate the growth rate. and than ask how many values you want to fill in. like if the answer is 5. only fillin the maximum last 5 mssing values. if any where 6 values are missing , leave that.

Note 2: I have 82 variables for which i want to do this.

after doing this make the fill in values cell formatting bule.

link of the file

https://skydrive.live.com/redir?resi...OAZx5ZHwRy0868