Using VBA

a. (5)Use A1 as the anchor cell and put your code within a With...End With structure b. (5)Use a For Next loop to loop through the customers c. (5)Inside the For Next loop in step b, use another For Next Loop to loop through the products d. (8)Inside the For Next loop in step c, determine the unit price each customer should pay for each product, based on the amount he/she purchased for the product. CHint: You can use cases structure, or If statement, or a combination of For Next loop and If statement) e. (6)Calculate the price each customer should pay for each product based on the unit price from step d (6)Print the result from step e to the cells F8:H22. For example, the price that customer 1 should pay for Product is printed in F8 g. (5)Calculate the total price each customer should pay by summing up the price for each product, and print the total in cells I8:122