Display cell from one worksheet into another

  • Thread starter Thread starter Linja
  • Start date Start date
L

Linja

Hi,

I would like to display a couple of cells from worksheet
no. 1 into worksheet no. 2, 3 and 4... so If I want to
change something I don't have to do that for each workbook,
only in no. 1.

Does anyone know how I can do this?

Thank you,

Linja
 
Select sheet 2, 3 and 4 by holding shift down while clicking on 2 and 4,
release shift, select the cell where you want the link and put

=

in the cell, now select sheet 1 and select the source cell, press enter.
repeat for the rest of the cells you want to link, finish by right clicking
any sheet tab of sheet 2 to 4 and select ungroup sheets
 
Back
Top