Formula that link worksheets

  • Thread starter Thread starter Wendy
  • Start date Start date
W

Wendy

Can anyone help me with the formula protocols for linking information
between worksheets in a workbook.

I know it is not the ideal software for what i am trying to achieve but
i am hoping to link income and expenditure worksheets to produce a
monthly report for a club i am involved with.

ie; data from sheet 1, 2, 3, & 4 linked to calculations in sheet 5
 
It sounds as if Excel *is* the ideal software for what you want to do.
You just need to learn how to use it <grin>. Try this example :-

To link a cell in the current sheet to another :-
1. Select any (target) cell in Sheet 1 and type an equals sign.
2. Click on the tab of the sheet with the cell you want to link to.
3. Click in the (source) cell.
4. Press the Enter key.
You end up with a formula something like : =Sheet2!A1

Whenever cell A1 in Sheet 2 changes, so will the target cell.

You can do a lot more than this. For example, by typing a + (or -, or
*, or /) sign instead of the Enter key in the example above you can
continue adding to your formula to include other cells and get
something like :-

=A1 - Sheet2!B1 + Sheet3!C2 + Sheet4!A12 + Sheet5!I13

This is just basic stuff. Excel can do a whole lot more ........
Suggest you get a beginners book and find out a bit more. You can
always come back here if you get stuck.


Regards
BrianB
=====================================
 
Back
Top