Microsoft Excel VBA – Post Training Activity 4

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”

Microsoft Excel – Post Training Activity 8

Hi Folks,

In the below listed table, you need to find the maximum value between two scenarios for each material and the result should be displayed with its respective sign. Your formula result should be exactly like the one we have under the required result column in the below screen shot.

Click here to download the exercise file

Use comments sections to post your answer or you can send me the completed file to my email. I will review and provide my feedback to you.