Forecasting using Trend Function Need to Update Each month with New Actuals

 I have over 25 products where I have 2 years of monthly history and I am using the Trend Array function to forecast the next year.  Every month I have a new month of data to add at the end of my actuals where the Trend funtion is located. How can I add my new month of data and not have to create 25 new trend array functions.

 Not sure how your Trend functions are already built, but can you use a named range and then you just need to expand that or you could use a OFFSET(....COUNTA....) function in the named range to 'auto-expand' the range. A little like this

http://www.contextures.com/xlNames01.html

 Thank I think that will work.