This video exhibits how to write code in Excel VBA that LOOPS through all the items in a DROPDOWN List in a workbook. In this example we have a workbook that contains formula ouputs of YearToDate Sales for any given branch in the DropDown List. The Formulas are driven to display sales based on which ever Branch is currently selected in the DropDown menu. The objective is to write code in VBA that will Loop through the entire list and make a copy of the workbook each time a new branch is selected and save that copy to a path on the Network Drive.

Learn More about Excel VBA & Macros with this Book on Amazon:
https://amzn.to/3xnqT6R

Get a Microsoft Office 365 Personal Subscription with this Amazon link:
https://amzn.to/3aV9GtL

DISCLAIMER: As an Amazon Affiliate I get a commission for every purchase via these links.

To get a copy of the workbook used in this video click on the link below and look for the title/filename that has the same name as this video title.

https://theexcelcave.weebly.com/excel...