Returning Text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

EASY. Thanks a lot

RobN said:
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
Click to expand...
 
Back
Top