In case if you are directly joining me in this post, request you to first complete user registration process and subscribe process. This will help you to get access other exercises as well.
Let’s start what we need to achieve in this exercise. First download the sample excel file by clicking here
In the downloaded sample excel file, I want your macro to do the below actions:
- Creating unique list of regions from the Region column available in the data
- This unique list should be made available in a new sheet in the same file in the A column
- If possible the new sheet should be named as “Master List”