Hi guys,

Recently I was away the last two days of class where the topics of VBA were introduced. I have no idea how to write VBA Coding, and I have this assignment due monday. Any help would be appreciated!

Write the VBA code for the following situations:


1.
An array of Currency values is called Sales. It contains all of the sales in a given month. Write the code to calculate the total sales in that month
and the average amount of a sale in that month. Declare all variables necessary.


2.
There are two arrays of the same size: Customers and Sales. The Customers array contains Long values, which are the Customer IDs. The
Sales array contains Integer values, and contains the number of sales made by each of those Customers. Sort the Sales array in order of highest
number of sales to lowest number of sales. Make sure to keep the Customers array values in the same order, so that the index of a Customer
ID would be the same index used in the Sales array to find their total sales.


NOTE: You can use whatever sorting algorithm you wish. If you don’t know any, you might need to find one online. You can use a separate
array to move the sorted items into temporarily, but then you must copy the values, in order, back into the Sales and Customers arrays.