Okay great. So I have a question. I run the code and it works great. Is there a way that I can change it to only copy the data from the row for A-F? Also I have a layout for the data to get copied to, and whenever I run the command button the layout is deleted. I'll attach a before and after photo

Before I run command button:
pic1.png
After I run it:
pic2.png