Assignment #12

1. Watch the video Sorting (MS Excel)   (CC).

2. Create an application using Visual Basic for Applications (VBA) similar to the one developed in the video and shown in the image below. (Assignment 12 - students). Your command buttons should sort data by various columns, extract the lowest two sales and highest two sales, Insert your name somewhere in the document.

   Note: Mac computers only support a restricted version of VBA. If your Mac computer does not allow you to complete this assignment, then complete either option A or B below.

   A. Write out all the code presented in this video and briefly comment what each line does. Save and upload this information to your website.

   B. Complete this assignment using the NSU Virtual Desktop. A link to this service can be found under Obtain access to MS Excel.

   
   
   
   
   
3. Explore the tutorial How to Sort Worksheets in Excel using VBA (alphabetically). Convince the instructor that you understand the key concepts in this tutorial by including one or more of the following: a summary of the tutorial, modified formulas similar to those covered in the tutorial, details, examples, charts, tips you learned, etc. Add this information (in a separate tab) to the document created in the previous step.
   
   
4. Save your work as "assignment12.xlsm" when you are finished. The "Save as type" should be "Excel Macro-Enabled Workbook (*.xlsm)".
   
   
5. Upload this file to YOUR-CLASS-WEBSITE.   Help