Posts by dfisch87


    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!