Answered step by step
Verified Expert Solution
Link Copied!

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 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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Data Mining

Authors: Pang Ning Tan, Michael Steinbach, Vipin Kumar

1st Edition

321321367, 978-0321321367

More Books

Students also viewed these Databases questions