VBA to create new workbook with 2 sheets of exsisting workbook

[igormigor]

Hi all,

I need help with the code below.

In the Workbook "Sample file", in sheet "Order" I have a complicated. This calculation , based on the selected/filled values in the yellow cells, it takes data from the sheets named with numbers (1,2,3,4,5,6,7,8,9, 11 (2)) and calculate the price of the chosen products.

In the sheet "Order Document-template" is summarized version of the calculation.

When I click the "Generate order" button in "Order" sheet, the macro creates new workbook with the "Order Document-template" sheet (with values only, hard copying the formulas), and renames the sheet to "Order Document".
If a values in column G in sheet "Order Document" is equal to 0, the rod is deleted.

Until now, the code works file.

I need also in the newly created document, aside "Order Document" sheet to be inserted another sheet ("Order inputs") in which will be the values and formatting in range "A1:F20" of sheet "Order".

I've attached 3 documents.
1. "Sample file" is the working document.
2. "How generated file looks" is the current look of the generated document.
3. "How generated file SHOULD look" is the sample file which shows how the generated document should look.

If the above is not clear enough, please let me know and I'll try to further explain the details.

Thank you in advance for your help.

Igor

Please Login or Register  to view this content.

How generated file looks.xlsb
How generated file SHOULD look.xlsb
Sample file.xlsb

[Kaper]

Hi Igor,

Try:

Please Login or Register  to view this content.

[igormigor]

Hi Kaper,

That's perfect!!! I've just made little adjustment at the end of your code, but it works perfectly. Thank you a lot!!!.

Igor

Please Login or Register  to view this content.