excel software training - Linking sheets to get reports

Hi Celina

Linking sheets is fairly simple. Like creating formulas, you can add cells together, you can do the same for multipl sheets.


so a basic formula is = A1+B1

When you link a sheet, you will get =Sheet2!A1+Sheet3!B1


Actions:

1. Click on the cell you want the answer to appear in
2. type =
3. click on the first sheet you want to add in, and select the cell you want to add
4. press +
5. nativate to the next sheet and cell, and then click on it.
6. repeat steps 4 and 5 until you have added all the cells you want to include for the answer.
7. Press Enter.

8. repeat for all the answers you want.

regards

Richard