| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| checking input in a cell and return by copying info from a other c | Excel Worksheet Functions | |||
| copy formula result (text) only - without copying formula | Excel Discussion (Misc queries) | |||
| COPYING SUM/IF FORMULA | Excel Discussion (Misc queries) | |||
| copying the Hyperlink function result without copying the actual formula | Excel Worksheet Functions | |||
| copying formula down | Excel Discussion (Misc queries) | |||
Linear Mode
