I asked elsewhere how to make a template automatically apply to all new sheets, which was answered by by Bentlybob.
I changed my template name to sheet and placed it in the C:\Program Files\Microsoft Office\Office12\XLSTART folder, problem is that this works fine manually but I need to make new sheets automatically when new product names are entered in collumn A.
Basically I need to edit this code

Please Login or Register  to view this content.
To make a new sheet from a template rather than blank.
Thanks for any advise