Question
You work in the office of Johnson's Appliance Center. Part of your job is to keep track of all pending sales orders and use this
You work in the office of Johnson's Appliance Center. Part of your job is to keep track of all pending sales orders and use this information to help your sales staff get jobs on the Delivery Schedule as soon as all items needed for the order are in stock. This Excel file is kept on the company server so all salespersons (Madison, Christine,Steve and John) can access it. However, the sales staff are not fluent in Excel and have trouble filtering the data to show just the orders that they need to schedule.
To assist the sales staff, create a macro for each of the four salespersons (Madison, Christine,Steve and John)that does the following:
Filters the list for their name in the Salesperson column
Shows Yes in the All Items in Stock column
Sorts the results by County in descending order.
After creating the macros, add a button near the top of the worksheet around row 3 for each salesperson so they can run the report.
Last, create a macro that resets the list to show all orders and add a button to run this macro in row 3 too. Add a Show All button at the top of the worksheet.
| Invoice No. | Customer | Amount | Salesperson | No. Pieces on Order | No. Pieces in Stock | All Items in Stock | County |
| 14718 | Adams, Alan | $ 11,188.00 | Madison | 8 | 7 | No | Orange |
| 14745 | Adazo, Maria | $ 14,901.00 | Madison | 5 | 4 | No | Osceola |
| 14188 | Brady, Retha | $ 2,885.00 | Christine | 5 | 4 | No | Seminole |
| 14898 | Brown, Barry & Liz | $ 9,319.00 | John | 2 | 2 | Yes | Orange |
| 14527 | Carole, Missy | $ 8,395.00 | John | 1 | 1 | Yes | Orange |
| 14821 | Gibbs, Rayven & Marcus | $ 9,114.00 | Steve | 7 | 7 | Yes | Brevard |
| 15208 | Gonstave, Rosemary | $ 2,406.00 | Christine | 3 | 2 | No | Seminole |
| 15500 | Henderson, John | $ 13,141.00 | Steve | 7 | 6 | No | Seminole |
| 14566 | Johson, Mary | $ 5,475.00 | Madison | 4 | 4 | Yes | Brevard |
| 14562 | Lanthier, Jacqueline | $ 8,753.00 | Christine | 6 | 6 | Yes | Seminole |
| 15618 | Lozano, Staci | $ 6,813.00 | John | 6 | 5 | No | Brevard |
| 14076 | Mezick, Melissa | $ 10,094.00 | Steve | 7 | 5 | No | Orange |
| 14965 | Morales, Patricia | $ 3,703.00 | Christine | 1 | 1 | Yes | Osceola |
| 14667 | Murray, Vivian | $ 10,911.00 | Christine | 2 | 2 | Yes | Brevard |
| 15080 | Nowak, Christine | $ 5,467.00 | Steve | 5 | 5 | Yes | Osceola |
| 14624 | Quinones, Jose | $ 7,353.00 | Christine | 3 | 3 | Yes | Osceola |
| 14018 | Rozelle, Mathew | $ 12,850.00 | Madison | 3 | 3 | Yes | Seminole |
| 14317 | Sawyer, Andrew | $ 7,956.00 | Christine | 4 | 3 | No | Orange |
| 15131 | Smith, Lucy & Joe | $ 2,675.00 | Steve | 3 | 2 | No | Seminole |
| 15940 | Thrush, Stephen | $ 1,277.00 | Madison | 1 | 1 | Yes | Brevard |
| 14295 | William, John | $ 15,200.00 | Christine | 4 | 4 | Yes | Seminole |
| 14424 | Williams, Shanya | $ 3,433.00 | John | 7 | 7 | Yes | Orange |
| 14393 | Zoulous, Lana | $ 10,276.00 | Madison | 1 | 1 | Yes | Brevard |
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
Put Your Data To Work 52 Tips And Techniques For Effectively Managing Your Database
Authors: Wes Trochlil
1st Edition
0880343079, 978-0880343077
