Copy sheet and macro's to a new sheet

[mad_Driver]

I am currently trying to create an order form and need some help customising it.
Due to the nature of the work done the size of the job varies greatly so I would like to be able to use a push button to produce a copy of a sheet inside the work book (this could be 1 copy to 20 + copies). At the same time i need the macro’s being used on the original to work on the new sheet(s) and if possible create a new row on the “totals” sheet in a designated position so that it can all be added up automatically.
I know it’s a lot to ask but if anyone knows how this can be done I would be very grateful.

[royUK]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

[mad_Driver]

Thanks for the advice royuk however because the document is for work it is protected by copyright preventing me from issuing it online, sorry

[mad_Driver]

hay,
Ive made some progerss and the sheet is being copied and retaining its macro functions in the same workbook.

I used:

Please Login or Register  to view this content.

All i need to know now is how to add a line in sheet ("Total") with the same functions as line (32) and put under line (32) but linked to the newly created sheet from the above code, using the same acctivation.
Thanks guys

update:

Got the new row inserting at the same time now but not able to link it to the newly created sheet code as follows:

Please Login or Register  to view this content.

[royUK]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here