Whenever I am trying to run all 7 groups through this batch macro I lose my formatting (See output worksheet in test.xlsx), but when I filter to only run a singular group the formatting is correct. I have no idea where the values in rows 2-26 are coming from. The browse within the batch macro shows the data formatted correctly as well.
@mquast This doesn't seem to be a batch macro. In order to run batches you will need a Control Parameter tool and an Action Tool configured. Please see: https://community.alteryx.com/t5/Interactive-Lessons/Creating-a-Batch-Macro/ta-p/657923