Use excel file as a template and save the result as a separate file

excel

#1

Hi all,

What would be the optimal way to do the following - paste values using write cell into an excel template with formulas and formatting and save as a separate file so that the template can be further reused.

Thank you,
Elizaveta


#2

Hi @Elizaveta_Demuynck,

You can keep your template in a common share path, when ever you need to create a new excel with this format then you can copy and paste this excel template into the new path. Then you can write the data on the copied new excel file.


#3

can you copy/paste formatting and formulas on the background?


#4

If your template has the formatting and formula the same will be retained during a file copy. I think no issue will come on that. But when you are writing data on that file only you have to consider that.