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.