This formula shows how to reference the cell in another worksheet using a formula. Begin the formula with an equal sign, and follow it with the name of the worksheet you wish to reference.

Q. I know how to link data from a cell in one worksheet to another worksheet, but how can I transfer a formula? A. To transfer data, enter them in sheet 1, go to sheet 2 and the cell in which you want ...

If you want to link multiple cells from another worksheet, you can use an array function, which lets you link a range of cells using one formula.