the trend value in 2018?

[2009luca]

i need, with vba code, to calculate the trend value in column 2018?


note:
the value in other years columns are the numbers of dossier worked in my office


sheet1

2012 2013 2014 2015 2016 2017 2018
1 0 0 6 0 0
0 3 0 0 0 6
34 2 6 7 2 0
3 0 0 0 1 0

http://files.engineering.com/getfil...0384-4c5a-87a1-04c0a1ebdbf0&file=Cartel1.xlsx

 

[mintjulep]

There is a native TREND()function.

No need to use VBA to calculate a trend.

 

[2009luca]

TREND()function....
how to with my data?

 

[SkipVought]

The x values are $A$1:$F$1
The y values are A2:F2
The new x values are $A$1:$G$1

Enter in G2.
Copy down thru the other rows of data.

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}