Link Cells In Excel

[Andycabot]

Hi, I'm trying to link a range of cells from one tab in an excel spreadsheet to another tab in the same workbook, but when I try to do it using paste special, the link icon doesn't show. I've tried typing the formula in manually but it just stays text and doesn't link.
Thanks

[Flonska]

Type an equals = sign in the cell you want the information to end up in, left click over to another worksheet, and left click on the cell you want to reference and then press ENTER. Excel should automatically enter it in.

[chelle7272]

If you want them linked so they both update it would be = in each cell click the cell on the other sheet and hit enter