Return of value when copying a formula

S

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.
 
S

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!

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


Stinky said:
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.
 
M

Max

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

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!

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


Stinky said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top