Copying to other worksheets

[Jerry Litt]

I would appreciate some help in the formula(s) for having the value in,
for example, cell B3 automatically being replicated in a selected cell
in worksheet2 or workshop3.

In a previous Email, it was suggested that the formula ="Sheet1' ! B3
would do the job. That did not work for me (unless I misunderstood.

Any help greatly appreciated.

Jerry Litt
(e-mail address removed)

 

[mudraker]

use formula =Sheet1!B3 - no spaces

or

on sheet2 cell a1 type =

then goto sheet1 and click in cell b3 - this will place the formula
=Sheet1!B3 in cell a1 on sheet

 

[Gord Dibben]

Jerry

If entered as you have written it out in this post, it will not work.

You have two errors.

Should be written as ='Sheet1'!B3

Note: no double quotes " and no spaces in the formula.

Gord Dibben XL2002

 

[Jerry Litt]

There were two responses to my question about Copying to other worksheets.
I'm afraid I still do not understand what to do. One suggested that I use:
formula =Sheet1!B3 - no spaces
or on sheet2 cell a1 type = then go to sheet 1 and click in cell b3

The other suggested that my example had two errors and should be written as:
='Sheet1'!B3

I can't get either of these to work. I obviously do not understand how to do

what is being suggested.

Jerry
(e-mail address removed)