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?
|