Linking Worksheets

The ability to link worksheets together is a vital skill for developing solutions to complex problems using MS Excel.

Linking is very easy to do.

What linking achieves is that changing figures on one worksheet makes automatic changes to another worksheet. This is very useful when, for example, you are compiling a budget which has information and calculations on many worksheets. In such a circumstance, you will need a summary sheet that is linked to all other sheets. If then a figure is changed on any worksheet, the summary will be automatically corrected.

Download a simple example in an MS Excel workbook.

Complete a workbook that users linking of worksheets.

For permission to utilise materials please email webmaster