Assignment 5 - STARTER (2).xlsmAssignment 5 - GRADER (2).xlsm

So he's the problem statement
In the starter file, you should place the code for the above cleaning process into the first part of the FormatAndIncompleteOrders sub (which is linked to the ?FORMAT & GENERATE INCOMPLETE ORDERS REPORT?).

Within the FormatAndIncompleteOrders sub should also be code that will generate a report of any incomplete orders. This means that any rows that have either the Title or Quantity missing (blank) should be copied over to the ?Incomplete Orders? sheet. These rows would also be eliminated from the original data on the ?New Orders? sheet.

The second main objective of this assignment is to generate a Store report from the Store that?s selected from the drop-down menu in cell H10. After a Store is selected in the drop-down list, the user can press the GENERATE STORE REPORT button, which runs the Report sub, the data will be filtered by column B, and only those rows that match the Store in cell H10 would be selected/copied and pasted over to the ?Report? sheet. Note that you are NOT removing the rows from the original data in the ?New Orders? sheet but are just copying over those orders that correspond to the Store in cell H10.