Task 7: Export Data from The Sales Template 

In this task, you will export data from the Sales Report Template using macros. To achieve this, you will need to accurately preview, adjust and print the template.

R 1. in the Template, implement Function 6 as per the Project Brief’s requirements: 

• record the macro and assign to the Import Past Data Macro Button 

• test the macro button and all other functionalities for accuracy 

• run the Export the Report Macro Button 

• output must conform to the Style Guide standards 

R 2. save and store the Template in accordance with organisational requirements 

R 3. request feedback from the Sales Manager (Assessor) on the draft Template 

R 4. after the receipt of this feedback, modify your draft template in light of the feedback received.

Appendix