Set Template = Sheets("Template") Template.Select Template.Copy After:=Template Sheets("Template (2)").Name = "ABL"
The code above is working to copy one sheet and move to a new sheet. However, I want to paste into the new sheet as values. I'm not sure how to do that.
Can someone help please?
Thanks for the help