How to Run Excel Macros

Creation date: 12/28/2018 3:29 PM Updated: 4/28/2023 1:31 PM macro

1. Export the OnlineSMART report to Required Format (CSV, Excel, Word) and open it
2. Open the macro you received
3. Select Enable Content. Depending on your Excel settings this may not be required; continue to step 5.
4. Select Enable Editing.
5. On your report CSV file go to View > Macros > View Macros
6. In the pop up box select the macro from the list and click Run. If the list is empty, ensure the Macros In drop down is set to All Open Workbooks.
7. Once the macro finishes running you will have an organized sheet and many reports will have configurable headers. Click the drop down arrow to set your criteria for inclusion in that particular column.