Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Create a template, on close, save those cells into another workshe

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!!
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default Create a template, on close, save those cells into another workshe

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Updating linked cells within a workbook, from worksheet to workshe notloiseweiss Excel Discussion (Misc queries) 7 February 18th 08 01:15 AM
Save unprotected cells from template to another workbook [email protected] Excel Discussion (Misc queries) 0 August 30th 06 06:02 AM
create chart /table excel-save, close & reopen colors change? Why Anne Charts and Charting in Excel 1 July 4th 06 09:16 PM
To save and close Steved Excel Worksheet Functions 5 July 27th 05 12:17 AM
How can I create a button to save one worksheet into a new workshe court Excel Discussion (Misc queries) 2 July 6th 05 06:39 PM


All times are GMT +1. The time now is 09:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"