excel microsoft training - Link Worksheets

Resolved · Low Priority · Version Standard

Link Worksheets

May has attended:
Excel Advanced course

by - delegate May [2 posts] (2008 Jan 25 Fri, 14:01) Reply

How do I link worksheets to another worksheet that gives the summary values of linked worksheets

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu	Bayswater	2	book now	£195	£205
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
Full Schedule: See all 109 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Link Worksheets

by - trainer Mark gold contributer [275 posts] (2008 Feb 1 Fri, 14:43) Reply

Hi May

Hope you are well
what you need to do

As long as you have a summary sheet for the totals, this is where you need to start writing and creating your links

firstly when you are linking formulas you need to use your mouse and your keyboard to create the formula, and i will show you an example of the formula below:

=E5+Sheet2!D3 this is how the formula looks, but when you create this you will need figures in both of the cells used in the formula then, on a blank cell type =e5+, then click the sheet 2 tab at the bottom of the screen then click on cell d3 when you have done that press enter

Hope this helps

Mark East

· Crazy Things People Have Done With Excel
· Tap the Power of Recorded Macros with MS Excel Courses
· Improve Performance Of Your Excel Macros
· An Introduction to Microsoft Excel: Top Features for the Excel Novice
· Microsoft Office and the Small Business: Part 1 Excel

Excel tip:

LARGE and SMALL functions and their uses

Two of Excel's most common functions are the MAX and MIN functions which will display the largest (MAX) or smallest (MIN) value in a series. What if you need the 2nd or 3rd largest or smallest values instead of the largest or smallest?

The =LARGE(array,n) returns the nth largest value of a series.

The =SMALL(array,n) function returns the nth smallest value of a series.

In both functions, 'n' represents the order of the number you want to display. For example, putting in 2 as n will give you the second highest number; putting in 3 as n will give you the third highest number.

View all Excel hints and tips

Rate this page: