Create an Excel template that takes advantage of multiple Sheets?

[mcbigj]

Hello,
I can create an Excel Template, no problem. But what I want to do is to be able to copy that template to additional worksheets when creating a new project from that template. Is it basically just a select all, copy, paste deal. or is there a better method for this. Maybe a macro?
Thanks.

 

[Dreamboat]

Try this out:

http://www.theofficeexperts.com/VBASamples/Excel03.htm

Anne Troy

http://www.TheOfficeExperts.com

 

[mcbigj]

I'll give it a try.
Thank you.