link cell from one sheet to another within the same workbook

[Lp]

how can I link cells on sheet 1 to sheet 2 within the same workbook?
Lp

[Gary''s Student]

Copy the cells on sheet 1 and paste/special on sheet 2 with link set
--
Gary's Student


"Lp" wrote:

> how can I link cells on sheet 1 to sheet 2 within the same workbook?
> Lp

[bpeltzer]

In sheet1, in the cell that should be linked, type = then click to the source
cell in sheet2. The result will be a formula like =Sheet2!A1. (You could
also just type the formula).

"Lp" wrote:

> how can I link cells on sheet 1 to sheet 2 within the same workbook?
> Lp