How to copy paste the excel template

i have to copy the excel template and paste in the same excel find the attachedd image.

One of the option is to use select range option, next Ctrl + C → move to second Excel and Ctrl + V.


it’s working but format is not coming i mean border styles and font style and all…

hi, have you solved this? I have 4 sheets of data in an excel file, I have to merge these 4 into one excel template. These 4 sheets are following the fixed template. But once write into another excel, formatting is lost

You can run a small macro to change the format and style when you open the excel using Invoke VBA activity.