Return of value when copying a formula
 

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.

Return of value when copying a formula
 

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


"Stinky" wrote:

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.

Return of value when copying a formula
 

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!

"Gary''s Student" wrote:

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


"Stinky" wrote:

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.

Return of value when copying a formula
 

The book might accidentally be in manual calc mode. Click Tools Options
Calculation tab check "Automatic" OK. voila? hit YES below
--
Max
Singapore
---
"Stinky" wrote:
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!

Return of value when copying a formula
 

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.

Stinky wrote:

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!

"Gary''s Student" wrote:

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


"Stinky" wrote:

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.

--

Dave Peterson