View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Marie Marie is offline
external usenet poster
 
Posts: 143
Default Using Multiple Worksheets

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.

"Pfizer Gal" wrote:

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?