SamT. The TempSwap is a bad habit I've formed to throw data on the sheet named "TempSwap", do something to it and then pick it back up for something else. the reason I delete it and add it back is that it seemed to run more quickly than clearing the data. It's lazy and there are probably a million ways to do it better but my goal is the destination moreso than the journey on some of these things. I will try this out and see how it fairs. Thank you so much!