Create automatically excel new file based on a template from info entered in another file

Good morning,

I have a file named "cargoes 2016" for which I created a userform in order to enter easily all the infos in all the relevant sheets. This works perfectly.

However I would like to add a new macro creating automatically a new file based on the template "CALC(P) - - - + CALC(S) - - -" and based of the new datas entered in cargos 2016 (i.e. after clicking on "add" on the user form of cargoes 2016.


However being totally inexperienced in VBA, I would like to know:

1. if my idea is feasible
2. any leads for further search on vba code/macro

Please note that for forum restrictions purposes, the file "CALC(P) - - - + CALC(S) - - -test" is actually a "Microsoft Excel Macro-Enabled Template (.xltm)"