Question: The spreadsheet Data 2 in the file Exam 1 . xlsx has sales totals for 1 2 months and 1 0 different products in the
The spreadsheet Data in the file Examxlsx has sales totals for months and different products in the range B:M
Write a VBA subroutine that:
Asks the user for a number from to January, December
Write the sum of the sales for the selected month at the end of the corresponding column for example, if the user entered number corresponding to April then the sum of the sales in the range E:E has to be written in cell E
Compute the minimum value among the sales of the selected months and the corresponding product to which the minimum corresponds for example, for the month of April the minimum value is which corresponds to Product
Displays in a message box the message You selected XXX The product with the minimum sale in this month is YYYY whose corresponding total sale is XXXFor example if the user entered number the message should say: You selected April. The product with the minimum sale in this month is Product whose corresponding total sale is
Make sure that the subroutine works properly when called multiple times
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
