Have you looked at the forecast function???
--
HTH...

Jim Thomlinson


"James" wrote:

Hi
I am trying to use excels regression function to predict sales in the
future. I have independant and dependant variables for six years (periods). I
also have the independant vairable for another 10 years and i want to get an
estimate of the dependant variable.
Any help would be appreciated
Thanks
James