Estimate future data based on past ones

[girapas]

I have some historical data from year 2009 till now, for each month of the year and for 7 items.
What I want is to make a report table (same or different Sheet) to automatically show a simple estimate of data for the future months (based on actual ones), every time I enter data for a month. I'm able to use Excel functions, like TREND, but I'm labouring to form that report.
Thanks in advance.

 

[PaddyD]

see if this helps:

http://www.tushar-mehta.com/publish_train/data_analysis/16.htm

 

[girapas]

Thanks for your help... and sorry for the delayed response.