Excel Forecasting

We have some sales data in a flat file that is structured like this at a transactional level: Product Date Quantity ABC 1-Nov-2018 24 ABC 5-Nov-2018 36 XYZ 12-Aug-2018 32 etc We want a macro VBA Program that can take this data and do the following: 1. Summarise to monthly level by product Store as a new sheet. 2. Apply the Excel Forecast Function to the monthly data for each product and output in the following format for the next 12 months in the future. Product Date Mean Upper Lower ABC 1-Dec-2018 32 28 16 ABC 1-Jan-2019 48 26 14 ... ABC 1-Nov-2019 40 45 24 XYZ 1-Dec-208 420 721 443 Thus if there are n products, we have n x 12 rows in the output. This should be saved as a new sheet in the workbook. 3. The above data, excel split into 4 rows, with dates a week apart and teh quantity divided by 4. The dates would be the 1st the 8th, the 15th and the 22nd. so we have n x 12 x 4 rows. Exmaple from above would be Product Date Mean Upper Lower ABC 1-Dec-2018 8 7 4 ABC 8-Dec 2018 8 7 4 ABC 15-Dec 2018 8 7 4 ABC 22 -Dec 2018 8 7 4 (ie the values are split into 4 equal amounts which total the month forecasts) Upper and lower are confidence bounds. Also stored as a sheet. It should be fully automatic.