Inserting new worksheet

[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 a job estimate on. What I would like to do is be able to insert a new worksheet (if needed by the user) at the end of the workbook that would paste all of the formatting and formulas from the original sheet and 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.

Thanks

[Don Guillett]

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

--
Don Guillett
SalesAid Software
[email protected]
"tanyhart" <[email protected]> wrote in
message news:[email protected]...
>
> 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 a
> job estimate on. What I would like to do is be able to insert a new
> worksheet (if needed by the user) at the end of the workbook that would
> paste all of the formatting and formulas from the original sheet and
> 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.
>
> Thanks
>
>
> --
> tanyhart
> ------------------------------------------------------------------------
> tanyhart's Profile:
> http://www.excelforum.com/member.php...o&userid=35148
> View this thread: http://www.excelforum.com/showthread...hreadid=549891
>