Thank you so much! I see this works great in my example, and in my actual working sheet too. The only problem is that I just need it to paste the values. I've been trying to figure out how I could add in:

Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
But to no avail. Thanks for your help!