VBA generate multiple report changing 1 parameter each time

    Hello,


    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!

    Re: VBA generate multiple report changing 1 parameter each time


    Probably at least for me, too difficult to do without the workbook.


    So if you want to upload the workbook.


    [sw]*[/sw]

    Bruce :cool:

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login