excel software training - Linking spreadsheets

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

Resolved · Low Priority · Version Standard

Linking spreadsheets

Jonas has attended:
Excel Introduction course

by - delegate Jonas [1 post] (2007 Mar 5 Mon, 09:41) Reply

How do i link two spreadsheets?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue	Bloomsbury	0	FULL
2003	2008 Nov 27 Thu	Southwark	3	book now	£210	£215
2007	2008 Nov 28 Fri	Bloomsbury	0	FULL
2003	2008 Dec 2 Tue	Bloomsbury	3	book now	£210	£215
2003	2008 Dec 4 Thu	Bayswater	6	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	5	book now	£212	£224
Full Schedule: See all 113 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: linking spreadsheets

by - trainer Amanda diamond contributer [1217 posts] (2007 Mar 5 Mon, 10:03) Reply

Hi Jonas

Thanks for your question.

You can link two spreadsheet together in one of two ways:

1. Copy the data from the source spreadsheet (the spreadsheet supplying the data), open the destination spreadsheet (the spreadsheet that will contain the link) then go to Edit - Paste special and select the Link option, click OK.

2. In the destination spreadsheet, start a formula by typing = into a cell then go to the source spreadsheet and click on the cell you want to link to, and press Enter.

Amanda

· Advanced level training: Microsoft Excel and the Web
· Microsoft Excel Training Courses or Consultants: Which Is Better For Your Company?
· From the Classroom to the Corporate World
· How Small Businesses Profit from Outside Excel Training
· Microsoft Excel's Best Kept Secret