Copying to other worksheets

  • Thread starter Thread starter Jerry Litt
  • Start date Start date
J

Jerry Litt

I sent the following message:
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.
============================================
This led to two responses, neither of which I could get to work. My example
was poor
as it should have been written as ='Sheet1'!B3 but using that didn't help.

Could we try again? I really am confused as one of the responses did not
have
Sheet1 written as 'Sheet1' while the other did!

Jerry Litt
(e-mail address removed)
 
Jerry,

It might be easier to do this:

1-First select the cell in worksheet 2 or 3 where you want
the value to be replicated.

2-In this cell, type the = sign and then click on
worksheet 1, cell b3 and hit enter.

This should create the formula you need.

-Jack
 
Jerry

=Sheet1!B3 is OK if there are no spaces in the sheetname.

='Sheet 1'!B3 is used if there could be/are spaces in the sheetname.

When posting I tend to insert the two single quotes just in case the OP has
spaces in the sheetname but has used a generic Sheet1 as an example.

Otherwise no difference.

Type an = sign in A1 on sheet2 but do not hit ENTER key.

Click on Sheet1 then click on B3 and hit ENTER key.

A1 on Sheet2 will contain =Sheet1!B3 in the formula bar and the value will be
in the cell.

Gord Dibben XL2002
 
Back
Top