Code for forecasting new records based upon database trends

[Brew]

How do I create a code that will find trends from all the “Y” records in the database range T4:T1004, and allow you to enter a number or range from 1 to 100 (in a msgbox), and run that number of new records within range T1005:T1104 to display which record are forecasted to be “Y” records based upon evaluation the trends from the database range

 

[tusharm]

Take a look at regression analysis techniques. Search google or visit
Trendline Coefficients and Regression Analysis
http://www.tushar-mehta.com/excel/tips/trendline_coefficients.htm

 

[montecarlo2012]

would be so good if you, please, upload the workbook for you wonderfull vba code. thanks.