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.
thanks,
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.