Hi,
I have many rows of data in one sheet showing productsales by month. I would like to be able to run a macro that cycles through eachrow and creates a Forecast Sheet (Excel 2016) with specific settings (such asthe end date and showing the stats table etc). Thats the first part, just creating a forecast sheet foreach product.
Secondly, I would then ideally like to be able to collatethe forecast columns together into one sheet so I have the actual sales figuresplus the forecast.
The second parts I can do manually if needed but Id ratherdo the whole thing with a macro if possible.
Many thanks in advance!
I have many rows of data in one sheet showing productsales by month. I would like to be able to run a macro that cycles through eachrow and creates a Forecast Sheet (Excel 2016) with specific settings (such asthe end date and showing the stats table etc). Thats the first part, just creating a forecast sheet foreach product.
Secondly, I would then ideally like to be able to collatethe forecast columns together into one sheet so I have the actual sales figuresplus the forecast.
The second parts I can do manually if needed but Id ratherdo the whole thing with a macro if possible.
Many thanks in advance!
