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

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

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