I have a template I have produced which generates a sales report.
Currently, I have a dropdown list in cell B5 of the worksheet "DAILY_Sales" which chooses the country.
After choosing the country, the report calculates.
I want to create a code which will loop through the dropdown list in B5, generate the report for each country, then save it as a new worksheet/ workbook (doesn't matter), and move on to the next country in B5.
Thank you in advance!