1. As the Sr. Data Analyst, you want to shorten the process of creating a Pivot table to compare the Sales figures between NA and Japan. Create a Macro to perform this operation for you with the click of a button. Insert a button to run this macro
   1. Create a new worksheet titled Q6Macro and insert a new pivot table for the data in the sheet Main
   2. Name the Macro as Q6Macro
   3. Run the Macro from View>Macros>View Macros to verify.
   4. Add a New Button titled Q6Macro and link it to the Macro created. Place this button on the top right of the sheet titled Q6Macro

[Hint: The Option to add a button is available in the Developer tab. If the Developer tab is not visible, goto File>Options>Customize Ribbon. Make sure that the Developer option is selected as shown

****Can you help explain how to create a Macro Button from a Pivot Table? I keep getting run-time errors