adding sheets based upon a template sheet
 

I am building a worksheet where I want to be able to create a number
of copies of an existing sheet. The purpose of this is to create a
detailed budget by station of a project. The project could have 1-20
stations. I want to start a macro that will copy the 'budgetsheet" a
number of times onto different worksheets within the workbook.

Example: Project A has 5 stations
copy the budgetsheet 5 times with in the workbook on seperate tabs

Hope this makes sense....

Thanks

Dennis

Email:

adding sheets based upon a template sheet
 

The trick here is to let Excel code the macro for you. Just click
Tools-Macro-Record New Macro. Then, select the template sheet. Edit - Move
or Copy Sheets - check Create a copy - OK.

Then, stop recording and look at the code Microsoft has written and adjust
as needed.


" wrote:

I am building a worksheet where I want to be able to create a number
of copies of an existing sheet. The purpose of this is to create a
detailed budget by station of a project. The project could have 1-20
stations. I want to start a macro that will copy the 'budgetsheet" a
number of times onto different worksheets within the workbook.

Example: Project A has 5 stations
copy the budgetsheet 5 times with in the workbook on seperate tabs

Hope this makes sense....

Thanks

Dennis

Email: