To run the final report procedure in Project #5, follow these steps:
Press Alt + F11 to open the Visual Basic for Applications (VBA) editor.
Insert a new module from Insert > Module.
Copy and paste the VBA code provided earlier for creating the final report macro into the module window.
Close the VBA editor.
Return to your Excel workbook.
Press Alt + F8 to open the "Run Macro" dialog box.
Select the final report macro from the list of available macros and click Run.
The macro will execute, creating the final report by compiling data from all worksheets in the workbook and displaying it in a new worksheet named "Final Report".
Ensure that you review the code and adjust any parameters or ranges as needed to fit your specific requirements before running the macro. Once the macro completes execution, you can review the generated final report in the "Final Report" worksheet.
Either way the teacher or student will get the solution to the problem within 24 hours.