We have a number of business processes that follow the same workflow:
- Feedback is needed on data (business need)
- Process
- Pull all data sources together needed for the person providing the feedback to respond appropriately
- Create an Excel workbook with the data drivers and column(s) of feedback that have data validation (selection lists) for the operator to choose from
- Burst the Excel Workbook by business division
- Send divisions their workbook
- Collect / Aggregate their responses
- Report on the results
I know how to burst data into multiple output when creating workbooks that will be overwritten with each workflow execution. How do I burst the data into a pre-formatted template that includes data validation?
