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 Data2 in the file Exam1.xlsx has sales totals for 12 months and 10 different products in the range B4:M13.
Write a VBA subroutine that:
Asks the user for a number from 1 to 12(1= January, 12= 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 4(corresponding to April) then the sum of the sales in the range E4:E13 has to be written in cell E14).
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 3880 which corresponds to Product 6).
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 XXX(For example if the user entered number 4, the message should say: You selected April. The product with the minimum sale in this month is Product6 whose corresponding total sale is 3880)
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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!