I want to Create One Report via Excel Macros

I have 3 courses that create 3 Excel worksheets that I want to combine into one worksheet.  How do I do that?

Create the Macro

  • Export your report to Excel.
  • Go to View - Macros - Record Macro
  • Enter a name for the macro - Select a Shortcut Key - Store the macro in "Personal Macro Workbook"
  • Note everything after this point is memorized
  • When you are done - go to Macros - Stop Recording
  • Save the report.
  • Select "Save All" to the comment below

 

Execute the Macro

  • Export your report to Excel.
  • Go to View - Macro - View Macros
  • Click Run on the macro you just created

 

VOILA!  You have just created and executed an Excel macro!

 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk