Inserting new worksheet

T

tanyhart

I am working on a workbook that is used to create estimates for jobs
Right now there is only one worksheet in it that the user can enter
job estimate on. What I would like to do is be able to insert a ne
worksheet (if needed by the user) at the end of the workbook that woul
paste all of the formatting and formulas from the original sheet an
enable the user to enter another job estimate.

I am new to VBA and am working very hard to learn.

Any help would be appreciated.

Thank
 
D

Don Guillett

Why not just start with the empty template and copy for each project needed
in that workbook.
right click sheet tab>copy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top