We typically do a lot of audits writing them to different tabs for a process. We have always used the block until done and not had any issues. Now that we are using amp mode that does not work anymore. I am trying to create a batch macro where I add a column "sheetname' to each output stream and union it into a macro. The problem is each sheet is way different from the other. My first attempt, it worked and created multiple sheets by sheetname, but all the fields from all the work flows show up (I assume the union tool created this). Has anyone created a macro that will take multiple (how many could be 3-10), and use the batch macro to feed one at a time so amp mode is not trying to write to multiple sheets at once? My other thought is multiple inputs, but not sure how to go about having 10 inputs, and only using 3. That seems like it would avoid the union issue in my first attempt.
