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 ...

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.

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.