vba excel - How do I link spreadsheets?

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

Resolved · Low Priority · Version Standard

How do I link spreadsheets?

Laura has attended:
Powerpoint Introduction course
Excel Introduction course

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

How do I link up several spreadsheets onto one?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Aug 28 Thu	Southwark	0	FULL
2002/XP	2008 Aug 29 Fri	Tooting	0	FULL
2003	2008 Sep 2 Tue	Bloomsbury	4	book now	£207	£215
2003	2008 Sep 4 Thu	Bayswater	5	book now	£195	£205
2007	2008 Sep 4 Thu	Bloomsbury	0	FULL
2003	2008 Sep 9 Tue	Bloomsbury	4	book now	£207	£215
Full Schedule: See all 139 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: How do I link spreadsheets?

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

Try this:

1. Select the cell you want to see the result in.
2. use a formula like

=Sheet2!B5+Sheet3!B5+Sheet4!B5

· How to Create Better Excel Spreadsheets: Part Three
· Prepare for your MOS Certification with MS Excel Courses
· Tips to Facilitate Printing of Excel worksheets
· Microsoft Excel Training: Not Just for Newbies Anymore
· How to Create Better Excel Spreadsheets: Part Two

Excel tip:

Fill formulae across a sheet

To copy a formula down a spreadsheet where there is data underneath, to the left or to the right of the formula, double-click on the fill handle. The fill handle is the little black cross that appears in the bottom right-hand corner of the formula cell. Unfortunately, no similar facility exists to copy formulae across the sheet.

One reasonably quick way to copy an existing formula across a sheet is to select the formula and the cells on the right to which you want to copy it. Then press Ctrl+R to copy the formula across the selected range, or, if you are menu-minded, use the Edit|Fill|Right command.

View all Excel hints and tips