Hello,

So i was able to figure out how to fix my issue using the code provided above. Then as everything started working correctly I noticed that I needed to remove any items in my "MasterSheet" table that was not also in the "DataSheet". This would happen because the case was completed and is no longer in the report.I have been trying to figure out a way to add a step to this that will go back and check if any of the items on "MasterSheet" are no longer in the "DataSheet" and remove them. Ideally I need to figure out a way to look at Column A "service case ID" and if it is not on both sheets.. remove it from "MasterSheet" as a completed item. NOTE: the problem before was not in the code it ( it worked just as it was supposed to. It was in the way I personally had my data coming in. It was a general text not a number. I'm really hoping someone can help here

The sheet above contains the working code and format of the tables.

Thanks so much in advance.