Dear Excel Forum,
The is the line of code I am using to copy the tab "PE Master" to the workbook I am currently in.
Workbooks("Profit Template.xlsm").Worksheets("PE Master").Range("A1:K200").Copy Destination:=Range("A1")
When I run the code, Excel opens a window and is looking for me to...