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

--
tanyhar
-----------------------------------------------------------------------
tanyhart's Profile: http://www.excelforum.com/member.php...fo&userid=3514
View this thread: http://www.excelforum.com/showthread.php?threadid=54989

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

--
Don Guillett
SalesAid Software

"tanyhart" wrote in
message ...

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