The file Recent Sales Finished.xlsm contains a list of a companys sales reps in the Sales Reps
Question:
The file Recent Sales Finished.xlsm contains a list of a company’s sales reps in the Sales Reps worksheet. For each of several Midwest states, there is a worksheet showing recent sales by the sales reps in that state. Open this file and click the button on the Sales Reps worksheet. You will see that it asks for a sales rep and then a state, and it summarizes sales by that rep in that state in a message box. Run this several times (including queries for reps and states not in the company’s list) to see all the functionality built into it. The code in this file is password-protected. Now open the file Recent Sales.xlsm, which contains only the data and a Main sub that calls some yet-to-be-written subs. Your job is to write the subs, using the arguments indicated in the Main sub, to achieve the same functionality. ( Note : Make sure that when you do a search for, say, Arnett, you don’t also find information for Barnett. Check out the various arguments for the Find function in VBA.)
Essentials of Statistics for Business and Economics
ISBN: 978-1305081598
7th edition
Authors: David Anderson, Thomas Williams, Dennis Sweeney, Jeffrey Cam