I have a forecasting model but I have 8 different categories to forecast on. I have wrote 1 macro that splits my data into 8 different csv files so I can then run each file through my forecasting model by attaching a macro.
I am trying to create a macro that feeds my model 1 spreadsheet at a time, I am trying to use a control & action batch macro but I am having trouble making it loop through all 8 csv files instead of just 1. I have attached the macro that I am currently trying to get working.
Any help would be appreciated.
Can you provide a minimum reproducible example of all the macros?