Multiple work sheets

Resolved · Urgent Priority · Version 2003

Dianah has attended:
Excel Intermediate course

by - delegate Dianah [1 post] (2008 Jun 17 Tue, 16:54) Reply

how would i link my information form worksheet to worksheet and formulate it to work together in calucation

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Nov 21 Fri	Bloomsbury	3	book now	£224	£235
2007	2008 Nov 27 Thu	Bloomsbury	4	book now	£240	£245
2003	2008 Nov 28 Fri	Southwark	1	book now	£235	£240
2003	2008 Dec 3 Wed	Bloomsbury	2	book now	£235	£240
2003	2008 Dec 5 Fri	Bayswater	6	book now	£195	£205
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
Full Schedule: See all 99 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: multiple work sheets

by - trainer Amanda diamond contributer [1208 posts] (2008 Jun 17 Tue, 17:06) Reply

Hi Dianah

Thank you for your question; and welcome to the forum.

To link one cell to another cell in a different worksheet is straightforward:

1. Select the cell you wish to create the link in.
2. Type in =
3. Select the cell that contains the data you wish to link to.
4. Press Enter.

This creates the link from one cell to another.

If you wish to add data from different cells together, select the cell containing the link and click in the formula bar at the top of the screen, type in + then select the cell that contains the data you want to add to the first cell you selected. Continue typing in + and selecting cells one at a time to include more cells in the calculation.

Always press Enter when you have finished.

If you are multiplying use * instead of +
If you are subtracting use - instead of +
If you are dividing use / instead of +

I hope this helps.
Amanda

· Interesting Lifestyle Applications for Microsoft Excel
· Microsoft Excel Courses Teach Advanced Macro Techniques
· 5 Microsoft Excel Charts for Creating Stunning Business Documents
· MS Excel: Excel At Making The Most Of Your Christmas
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel

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

Excel tip:

Edit and format multiple worksheets in one operation

To select two or more non-adjacent worksheets, click on the tab of each worksheet, while holding down the [CTRL] key.
To select two or more adjacent worksheets, click on the tab of the first worksheet and then on the tab of the last worksheet, while holding down the [SHIFT] key.
Enter or modify your data and apply the necessary formatting options to the sheet that's displayed

View all Excel hints and tips