Duplicate information

Resolved · Low Priority · Version Standard

Kathleen has attended:
Powerpoint Advanced course

by - delegate Kathleen [4 posts] (2008 Feb 22 Fri, 16:59) Reply

How can I duplicate information so it changes on another sheet as i type information on the first sheet?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Dec 8 Mon	Bayswater	2	book now	£224	£224
2007	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 9 Tue	Tooting	0	FULL
2003	2008 Dec 11 Thu	Southwark	7	book now	£188	£215
2007	2008 Dec 16 Tue	Bayswater	6	book now	£207	£215
2002/XP	2008 Dec 16 Tue	Tooting	0	FULL
Full Schedule: See all 108 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: duplicate information

by - trainer Rich platinum contributer [744 posts] (2008 Feb 23 Sat, 21:36) Reply

On the second sheet copy over all the headings if required. In the first cell type = and then go to the first sheet and click the cell you want it to map to. Press the enter key and that cell will always be mapped. On the second sheet you can drag down the formula to map the rest. Please see the attached spreadsheet

Attached files...

Example1.xls

· Benefits of learning about Excel charts
· Microsoft Excel Training: Essential for Today's Employees
· Crazy Things People Have Done With Excel
· How to Create Better Excel Spreadsheets: Part Four
· Do You Really Need Excel VBA Training?

Please browse our web site to find out more about
excel computer course london and other Microsoft training courses.

Excel tip:

New Normal Worksheet

Do you want all your worksheets to confirm to a certain look? Then change the Defaults!!!
1. Press Shift+F11 to create a new worksheet
2. Press Ctrl+A to select (higlight) all cells, Press Ctrl+1, make any formatting changes then click OK.
3. Press F12 (Function 12 key) click in the Save As Type, drop down, then select Template (*.xlt)
4. Click in the Save in drop-down, then find the folder; c:_program files_microsoft office_office_start. (For the underscores shown use backslash)
Name your templete sheet.xlt, then press Enter.
Sheet.xlt is used when you insert a new worksheet (Shift+F11)

Note: These changes are permanent changes on your PC.

View all Excel hints and tips

Rate this page: