Vba code for coping xlsm file with formatting and formulas, but without user data entries

[absoftver]

Hi guys,

I have .xlsm file which I use for creating orders to our supplier and sending them in pdf file type format automatically using button Send order.

What I need is a vba code which will create a copy of complete workbook template keeping formulas and all formatting, but without data about products ordered (rows from 10 further). New order shoud be created by clicking on button Create new order and saved in same file directory but with different name.

I am kind of stuck with issue and would appreciate your help.

Thank you very much.

Petra

 

[Belleke]

Something like this?
See attatched

 

[absoftver]

Belleke,

Not something like that, but exactly like that. Thank you very very much, I really appreciate your time and help.

Petra

 

[Belleke]

Thank you for the feedback.
Just curious, what is the language in your example?

 

[absoftver]

Croatian

I will translate my final template version into English in case someone would need something like this.

 

[Belleke]

Thank you for your reply.
I am from the Dutch speaking part of Belgium, and one of my best friends is Croation. (lives in Belgium, came here during the Yugoslav Wars)
Have a nice day and Suc6