See Ron de Bruin's site for various types of code.

http://www.rondebruin.nl/tips.htm

Look under Copy/Paste/Merge Examples.

The code would be inserted in the Template.


Gord Dibben MS Excel MVP

On Mon, 5 Mar 2007 03:13:00 -0800, kangasnat
wrote:

Hi, I am hoping someone can help me as I'm desperate! I am trying to create
a template in Excel which upon closing, all of the information is transferred
to another worksheet. Each time someone fills in this generic 'form' (from
the template) the then new information is added continuously to the specified
worksheet, eg.
Name
Language Spoken
Skills
Please help!!