Linking worksheets

Hello Ania,

Hope you enjoyed your Microsoft Excel Advanced course with Best STL.

Thank you for your question regarding linking worksheets.

Whenever you wish to link one worksheet to another, you need to place a formula in a cell on the worksheet where you require the value to go. This formula will include a reference to a cell in the other worksheet and after you press enter the result will appear and the sheets are now linked.

To do this...

1) Click on the worksheet cell where you want the result to appear
2) Press = and then begin your formula
3) When you need to use a cell in the other sheet, click the sheet tab then click the required cell
4) You may need to press enter at this point if the formula is complete, however, should you require to use further cells in the first sheet then click the sheet tab, continue with the formula and press enter when finished.

Use this method to link any worksheet with another.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer