I want to set up a function that will look in a sheet and bring the text
contained in a cell to another sheet.

For example, cell A1 in sheet 1 contains the text "Mike". I want the
contents of A1 to be replicated in cell A1, sheet 2. If I change "Mike" to
"Jim" I want A1, sheet 2 to update to "Jim".

I can do it with numbers by simply using the autosum function but it doesn't
work with text.

Many thanks, Guys

Simon

In Sheet2, cell A1 enter:

=Sheet1!A1

--
Gary''s Student - gsnu200738


"Simon y Glog" wrote:

I want to set up a function that will look in a sheet and bring the text
contained in a cell to another sheet.

For example, cell A1 in sheet 1 contains the text "Mike". I want the
contents of A1 to be replicated in cell A1, sheet 2. If I change "Mike" to
"Jim" I want A1, sheet 2 to update to "Jim".

I can do it with numbers by simply using the autosum function but it doesn't
work with text.

Many thanks, Guys

Simon

Unless I'm not reading your Q properly,
simply click in the Sheet2 A1 cell and type = and then click the Sheet1 tab
and click in cell A1 and then press enter.
Now Sheet1 A1 will always be replicated in Sheet2 A1.
The formula should look like this
=Sheet1!A1
(You can of course simply paste this formula into A1 on sheet2, but I wasn't
sure if they are the names of your sheets.)
So, all this is doing is creating a formula that says Sheet2 A1= Sheet1 A1

Rob

"Simon y Glog" wrote in message
...
I want to set up a function that will look in a sheet and bring the text
contained in a cell to another sheet.

For example, cell A1 in sheet 1 contains the text "Mike". I want the
contents of A1 to be replicated in cell A1, sheet 2. If I change "Mike" to
"Jim" I want A1, sheet 2 to update to "Jim".

I can do it with numbers by simply using the autosum function but it
doesn't
work with text.

Many thanks, Guys

Simon

Guys -

EASY. Thanks a lot

"RobN" wrote:

Unless I'm not reading your Q properly,
simply click in the Sheet2 A1 cell and type = and then click the Sheet1 tab
and click in cell A1 and then press enter.
Now Sheet1 A1 will always be replicated in Sheet2 A1.
The formula should look like this
=Sheet1!A1
(You can of course simply paste this formula into A1 on sheet2, but I wasn't
sure if they are the names of your sheets.)
So, all this is doing is creating a formula that says Sheet2 A1= Sheet1 A1

Rob

"Simon y Glog" wrote in message
...
I want to set up a function that will look in a sheet and bring the text
contained in a cell to another sheet.

For example, cell A1 in sheet 1 contains the text "Mike". I want the
contents of A1 to be replicated in cell A1, sheet 2. If I change "Mike" to
"Jim" I want A1, sheet 2 to update to "Jim".

I can do it with numbers by simply using the autosum function but it
doesn't
work with text.

Many thanks, Guys

Simon