Okay, it was working and somehow I broke it by changing things... However, it was working fine and then it stopped somehow. I made it to where I am pulling my individual sheet data from a primary table so that changes to # can be made quickly if need be. I am getting an error13 and it highlights the problem code. I'm sure this is probably an easy fix PROJECT2.xlsm