Using Multiple Worksheets

P

Pfizer Gal

I have 3 worksheets and I want to link one cell in one worksheet to another.
The first worksheet cell has a formula in it. How do I get a cell from one
worksheet to enter data into another cell on another worksheet?
 
P

Peo Sjoblom

Copy the cell, select where you want the link and do edit>paste special and
select paste link


--


Regards,


Peo Sjoblom
 
S

sb1920alk

In the destination cell, type the equal sign =
then click the tab and then the cell containing the source value you want.
Excel will write the formula for you. It will look something like =Sheet1!A1
 
F

FSt1

hi
a simple formula will do.
on sheet 2 cell a1, enter = sheet1!A1
what ever is in sheet1 cell a1 will appear in sheet2 cell a1.

adjust to suit.
Regards
FSt1
 
M

Marie

Simple......... cursor in destination cell hit + go to cell you want copied
(do not hit enter key in the mean time) when you get to the cell you want
copied hit enter...........voila........ they are linked. If you want the
destination cell to be a hard number then do a copy/paste value .

Unless I totally misunderstood the question.
 
H

Harald Staff

Cells can not write to other cells, other cells must fetch their own value
by containing a formula.

HTH. Best wishes Harald
 
Top