how do I replicate text from one sheet to another like "=sheet!F2"
 

To copy or link mathematimatical functions to a blank worksheet I use =then
click the worksheet and the cell or group of cells I want to copy or link. To
copy or link text on a cell or group of cells gives me an error. please help

how do I replicate text from one sheet to another like "=sheet!F2"
 

It should work in a similar fashion. If cell A1 in Sheet1 contains:

Hello World

then enter in cell A1 in Sheet2:

=Sheet1!A1
--
Gary''s Student - gsnu200780


"copying text within excel worksheets" wrote:

To copy or link mathematimatical functions to a blank worksheet I use =then
click the worksheet and the cell or group of cells I want to copy or link. To
copy or link text on a cell or group of cells gives me an error. please help

how do I replicate text from one sheet to another like "=sheet!F2"
 

If you're pointing at multiple cells on the "sending" sheet, you could select
the same size range in the "receiving" sheet and hit ctrl-shift-enter to make
sure you're array entering this formula.

Personally, I don't think I'd do that.

I'd select the sending cells
edit|Copy
I'd select the top left corner of the receiving range
edit|Paste special|Paste link

============
But I don't like the formulas that either of these methods return.

I don't like:
=sheet2!a1
I like:
=if(sheet2!a1="","",sheet2!a1)

This keeps the receiving cell from showing 0 if the sending cell is empty.

copying text within excel worksheets wrote:

To copy or link mathematimatical functions to a blank worksheet I use =then
click the worksheet and the cell or group of cells I want to copy or link. To
copy or link text on a cell or group of cells gives me an error. please help

--

Dave Peterson