Create a template, on close, save those cells into another workshe

[Guest]

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!!

 

[Gord Dibben]

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