Excel VBA Examination

This is to test whether you really learned from the tutorial. It takes more practice for you to learn in excel macro. You can do any procedure you want as long as the output is the same.

1. Please make a workbook as shown below. In a workbook, create three sheets and rename it accordingly. You need to make a program where in the summary of the rating per employee in its designated department as shown in sheet Summary. Please assign your macro in a button.

2. We will  use the same workbook you created.
    Please create individual excel file per employee. You need to have 5 workbooks all in all with a filename of employee such as Berna.xlsx, Crizel.xlsx etc.

3. You created already the workbook?
   If yes, now do it again. However, this time you will add more code in your program.
   When you save the workbook, add a code that it will open the file, then automatically create the following:

There's one more. After, you created above template, input all the values automatically.

If you able to answer all of the program above than you are now one step closer to the world of VBA.

Now you are ready, you can study Function and Userform.