Using Multiple Worksheets

  • Thread starter Thread starter Pfizer Gal
  • Start date Start date
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?
 
Copy the cell, select where you want the link and do edit>paste special and
select paste link


--


Regards,


Peo Sjoblom
 
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
 
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
 
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.
 
Cells can not write to other cells, other cells must fetch their own value
by containing a formula.

HTH. Best wishes Harald
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Highlighting duplicates 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel VBA 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Referrences of multiple cells from one worksheet to another 3
Working with multiple worksheets at the same time. 6
Excel 2003 worksheet connections 3
Sorting in multiple worksheets 1

Back
Top