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!
0 Comments