Return of value when copying a formula

[Stinky]

I've created a v simple [= function] in order to get data from one
spreadsheet to another. However, when I copy the function across the
spreadsheet, it is returning the value of the copied cell, not the value of
the cell the formula points to.

 

[Gary''s Student]

Post your formula.

 

[Stinky]

I'm in Sheet2, and use the formula:

=Sheet1!B2

In order to repeat data from Sheet 1.

When I copy this down the col the formula changes to =Sheet1!B3, =Sheet1!B4
etc as you would expect, but I get the value of Sheet1!B2 (which happens to
be 1) instead of the value in Sheet1!B3 (which should be 2) and Sheet1!B4
(which should be 3) etc.

Thanks!

Post your formula.
--
Gary''s Student - gsnu201001

I've created a v simple [= function] in order to get data from one
spreadsheet to another. However, when I copy the function across the
spreadsheet, it is returning the value of the copied cell, not the value of
the cell the formula points to.

 

[Max]

The book might accidentally be in manual calc mode. Click Tools > Options >
Calculation tab > check "Automatic" > OK. voila? hit YES below

 

[Dave Peterson]

Max gave you the solution, but you may want to use a formula like:

=if(Sheet1!B2="","",sheet1!b2)

Then those empty cells on sheet1 won't return 0's.

I'm in Sheet2, and use the formula:

=Sheet1!B2

In order to repeat data from Sheet 1.

When I copy this down the col the formula changes to =Sheet1!B3, =Sheet1!B4
etc as you would expect, but I get the value of Sheet1!B2 (which happens to
be 1) instead of the value in Sheet1!B3 (which should be 2) and Sheet1!B4
(which should be 3) etc.

Thanks!

Post your formula.
--
Gary''s Student - gsnu201001

I've created a v simple [= function] in order to get data from one
spreadsheet to another. However, when I copy the function across the
spreadsheet, it is returning the value of the copied cell, not the value of
the cell the formula points to.