Link Between Worksheets

Linking formulas can transfer a value to a new place in a different worksheet in the same workbook.

When you create a linking formula, it brings forward the value to a new location and the result in the linking formula remains dynamically linkedto the original.
If you change the original value or any of the source cells referred to in the linking formula, the result in the linking cell is updated at the same time.

Highlights

Understand the syntax of formulas with links to other worksheets within a workbook
Create formulas with links to other worksheets
Copy formulas with links to other worksheets

Duration: 4mins 56secs

from