SmartList Builder 2016
Consolidating Reports Into A Single Worksheet
When a report has been consolidated into a single workbook, you can also choose to consolidate it into a single worksheet with all companies displayed in a single table.
To consolidate reports into a single worksheet:
| 1. | Click the Options button. |
| 2. | Mark the Multicompany report option and mark the companies that you want included in the Excel Report. |
| 3. | Mark the Consolidate all reports into a single workbook option. |
| 4. | Mark the Consolidate all reports into a single worksheet option. |
| 5. | Click Save. |