Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I use the value from a cell in one worksheet in another
Here is my question with detail. In one worksheet I have a value, that is
created by a formula, in a cell. I would like to copy the result of that formula to a cell in another worksheet. However if the value created by the formula has not been generated, that is the cell is empty, apart from the formula, I would like the cell in the other worksheet to be left blank. The second worksheet cell will have a formula in it to use the value of the first worksheet. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I use the value from a cell in one worksheet in another
Check your first post.
elusiverunner wrote: Here is my question with detail. In one worksheet I have a value, that is created by a formula, in a cell. I would like to copy the result of that formula to a cell in another worksheet. However if the value created by the formula has not been generated, that is the cell is empty, apart from the formula, I would like the cell in the other worksheet to be left blank. The second worksheet cell will have a formula in it to use the value of the first worksheet. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I use the value from a cell in one worksheet in anothe
"Dave Peterson" wrote: Check your first post. -- Dave Peterson Dave - thanks very much for your quick reply. I followed your instructions for both questions I asked. However, in the second question where I need the results from a formula to be added to a value in a cell in sheet 2 or remain blank I get zeros. The formula I am putting in is below =IF('Fuel Consumption 08'!D23="","",'Fuel Consumption 08'!D23+B17) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I use the value from a cell in one worksheet in anothe
Doesn't your formula work ok?
If D23 on that 'fuel consuption 08' is an empty string (or completely empty), then that cell with the formula should look empty (it'll actually evaluate to ""). Maybe the formula in D23 needs to be changed to make sure it returns "" when it needs to appear empty. elusiverunner wrote: "Dave Peterson" wrote: Check your first post. -- Dave Peterson Dave - thanks very much for your quick reply. I followed your instructions for both questions I asked. However, in the second question where I need the results from a formula to be added to a value in a cell in sheet 2 or remain blank I get zeros. The formula I am putting in is below =IF('Fuel Consumption 08'!D23="","",'Fuel Consumption 08'!D23+B17) -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I use the value from a cell in one worksheet in anothe
Dave - the only thing in cell D23 is a formula which creates a value in cell
D23. When the formula is removed from D23 meaning there is absolutely nothing in it then the formula you gave me probuces a blank cell in the Fuel Consumption 2008(a) worksheet. "Dave Peterson" wrote: Doesn't your formula work ok? If D23 on that 'fuel consuption 08' is an empty string (or completely empty), then that cell with the formula should look empty (it'll actually evaluate to ""). Maybe the formula in D23 needs to be changed to make sure it returns "" when it needs to appear empty. elusiverunner wrote: "Dave Peterson" wrote: Check your first post. -- Dave Peterson Dave - thanks very much for your quick reply. I followed your instructions for both questions I asked. However, in the second question where I need the results from a formula to be added to a value in a cell in sheet 2 or remain blank I get zeros. The formula I am putting in is below =IF('Fuel Consumption 08'!D23="","",'Fuel Consumption 08'!D23+B17) -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I use the value from a cell in one worksheet in anothe
Do you want to share the value that's returned in D23?
Do you want to share the formula in D23 and the values of any of the cells that this formula depends on? Without those, I don't think anyone will be able to make an informed guess. elusiverunner wrote: Dave - the only thing in cell D23 is a formula which creates a value in cell D23. When the formula is removed from D23 meaning there is absolutely nothing in it then the formula you gave me probuces a blank cell in the Fuel Consumption 2008(a) worksheet. "Dave Peterson" wrote: Doesn't your formula work ok? If D23 on that 'fuel consuption 08' is an empty string (or completely empty), then that cell with the formula should look empty (it'll actually evaluate to ""). Maybe the formula in D23 needs to be changed to make sure it returns "" when it needs to appear empty. elusiverunner wrote: "Dave Peterson" wrote: Check your first post. -- Dave Peterson Dave - thanks very much for your quick reply. I followed your instructions for both questions I asked. However, in the second question where I need the results from a formula to be added to a value in a cell in sheet 2 or remain blank I get zeros. The formula I am putting in is below =IF('Fuel Consumption 08'!D23="","",'Fuel Consumption 08'!D23+B17) -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If in specific cell in any worksheet but worksheet one add to spec | Excel Worksheet Functions | |||
populate cell on worksheet 2 if text is red on worksheet 1 | Excel Worksheet Functions | |||
How do I take a cell in one worksheet and add it into the formula in a different worksheet in the same workbook? | Excel Worksheet Functions | |||
How can I link cell colours from worksheet to worksheet/workbook? | Excel Worksheet Functions | |||
Worksheet reference (i.e placing worksheet name in a cell) | Excel Worksheet Functions |