Marvin, thanks for pointing me in the right direction. I was going around in circles trying to find something wrong with the code while it was just getting ahead of itself.

I am going to call this one solved. Not exactly what I was looking for, but it works. Instead of combining both into one macro, I just added a button for the user and one will update the data, and the other will reformat the results. This after trying a wait statement to give it a few seconds to update which didn't work either. Anyway, the 2 macro solution will work.