Add a tamplate sheet automaticly when I have copy in a new sheet
 

Hi

I have one workbook with a lot of sheet. My intention is to add a
tamplate sheet automaticly when I have copy in a new sheet.
So when i Copy in a new sheet named i.e John I want excel to insert a
template sheet from file (i.e d:template). Then name the inserted
sheet, i.e John_st. Next time when i copy in a sheet (Steve), then
insert the template sheet and named is Steve_st. The sheet i copy to my
workbook have already the name John or Steve or.....

Thanks

regards Rune


--
mowen
------------------------------------------------------------------------
mowen's Profile: http://www.excelforum.com/member.php...fo&userid=8463
View this thread: http://www.excelforum.com/showthread...hreadid=413862