Need help with this.

This requires you to explore more information on macros. Since most Excel users are not programmers who know VBA code, this gives you more practice on recording macros without writing any VBA code.

If you do not have PowerPoint on your computer, you may download the PowerPoint viewer for free athttp://www.microsoft.com/en-us/download/details.aspx?id=13

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.

Open theIP_Macros_PendingSales_2017.xlsxfile.

To assist the sales staff, make 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, make 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.

Format the worksheet to print professionally.

I took a screenshot because it kept saying file not supported.

AutoSave OFF IP_Macros_PendingSales_2017 Q ~ Search Sheet Home Insert Page Layout Formulas Data Review View Share 36 Calibri (Body) 11 A- A- % Conditional Formatting Format as Table Q Paste I U . . . Ax Number Cell Styles Cells Editing K3 fx B C D E F G H Johnson's Appliance Centre N Pending Sales Order Status 3 No. Pieces No. Pieces All Items Invoice No Customer Amount Salesperson on Order in Stock in Stock County 14718 Adams, Alar 11,188.00 Madison No Orange 14745 Adazo, Maria 14,901.00 Madison No Osceola 14188 Brady, Retha 2,885.00 Christine No Semin 14898 Brown, Barry & Liz 9,319.00 John Yes Orange 14527 Carole, Missy B,395.00 John Yes Orange HS 14821 Gibbs, Rayven & Marcus 9,114.00 Steve Yes Brevard 11 15208 Gonstave, Rosemary 2,406.00 Christine IN No Seminole 12 15500 Henderson, John 13,141.00 Steve No Seminole 13 14566 Johson, Mary 5,475.00 Madison Yes Brevard 14 14562 Lanthier, Jacqueline 8,753.00 Christine Seminole 15 15618 Lozano, Staci 6,813.00 John Brevard IWAW WW NHGOPNW NEN 16 14076 Mezick, Melissa 10,094.00 Steve Orange 14965 Morales, Patricia 3,703.00 Christine Osceola 14667 Murray, Vivian 10,911.00 Christine Brevard 14 15080 Nowak, Christine 5,467.00 Steve Osceola IHN hmmme 20 14624 Quinones, Jose 7,353.00 Christine Osceola 21 14018 Rozelle, Mathew 12,850.00 Madison Seminole 24 14317 Sawyer, Andrew 7,956.00 Christine Orange 15131 Smith, Lucy & Joe 2,675.00 Steve Seminole 24 15940 Thrush, Stephen 1,277.00 Madison Brevard 25 14295 William, John 15,200.00 Christine 1 4 Semin 26 14424 Williams, Shanya 3,433.00 John Yes Orange 27 14393 Zoulous, Lana 10,276.00 Madison Brevard 97 29 30 Pending Sales + Ready 100%