scottandersonn
New Member
- Joined
- Oct 1, 2019
- Messages
- 6
Hello everyone
Suppose if I have a list of countries in column A in a "master" sheet, and all the other sheets are named after each country with more details contained within each sheet.
I want to create a macro which will iterate through my list of countries, refer to the sheet of that country, perform a function I already have, then move onto the next country in the list.
Is this a practice possible or very complex?
Happy to provide further examples of code or examples if need be.
Any help is greatly appreciated, Scott.
Suppose if I have a list of countries in column A in a "master" sheet, and all the other sheets are named after each country with more details contained within each sheet.
I want to create a macro which will iterate through my list of countries, refer to the sheet of that country, perform a function I already have, then move onto the next country in the list.
Is this a practice possible or very complex?
Happy to provide further examples of code or examples if need be.
Any help is greatly appreciated, Scott.