training excel vba - Mark up sheets in excel with duplicate data

The UK's most regular instructor-led training courses.
Training information: training excel vba · Microsoft+excel+training · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Mark up sheets in excel with duplicate data

Peter has attended:
Excel Introduction course

by - delegate Peter [1 post] (2007 Mar 12 Mon, 16:18) Reply

How do you save the base layout to further sheets without copying the whole sheet onto a blank sheet. Say if you have 12 sheets and need to transfer the basics information for future input of data.

Thanks

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue + 26 Wed	Bayswater	6	book now	£455	£515
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 1 Mon + 2 Tue	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	5	book now	£450	£485
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	5	book now	£475	£515
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	6	book now	£450	£475
Full Schedule: See all 37 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Mark up sheets in excel with duplicate data

by - trainer Richard platinum contributer [818 posts] (2007 Mar 12 Mon, 16:34) Reply

You can save a template.

FILE > SAVE AS

Give the file a name, as you would a normal file,
Select the file type TEMPLATE (*.xlt)
Click OK

This saves the file as a template in a TEMPLATE directory, which is available from FILE > NEW, Templates on my computer. This templatye can be edited and then resaved if you have any fundamental changes.

· From the Classroom to the Corporate World
· Microsoft Excel Training Courses or Consultants: Which Is Better For Your Company?
· How to Create Better Excel Spreadsheets: Part Two
· Microsoft Excel Training Course
· Microsoft Excel Training: Not Just for Newbies Anymore

Excel tip:

Copying Formulae Quickly

There is a quicker way of copying a formula down a column.

Just point and double click on the black autofill handle in the right hand corner of a cell.

This will work providing you have some data in the column to the left of the column.

Sandy

View all Excel hints and tips