Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started