Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Multiple work sheets

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Multiple work sheets

Resolved · Urgent Priority · Version 2003

Reply Tue 17 Jun 2008, 16:54Delegate Dianah said...

Dianah has attended:
Excel Intermediate course

Multiple work sheets

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

For upcoming training course dates see: Pricing & availability

Reply Tue 17 Jun 2008, 17:06Trainer Amanda said...

RE: multiple work sheets

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

Excel articles

· Microsoft Excel can ensure you keep on top of your finances
· Why Excel Has More Cloud Coverage
· What's mine is yours: Sharing data in Excel
· Trust Excel To Protect Your Data
· Create A Basic Timeline In Excel

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

Excel tip:

Generating Random Numbers

To generate a random number in Excel use the = RAND() function.

The value returned will always be between 0 and 1. To convert this to some other random value, you will need to multiply the result by the highest number you want to consider. For example, if you wanted a random number between 1 and 25, you could use the following code line:
= INT(25 * RAND()+ 1)

Since RAND() will always returns a value between 0 and 1 (but never 1 itself), multiplying what it returns by 25 and then using the Integer function INT on that result will return a whole number between 0 and 24.

Finally, 1 is added to this result, so that x will be equal to a number between 1 and 25, inclusive

View all Excel hints and tips