Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using multiple sheets from a workbook in a formula
If I want to use a cell value in a formula, but the cell is from another
worksheet in the same book, how do I do this? I thought I just entered = into the formula box then clicked onto the other worksheet and selected the cell, but that doesnt seem to be working, any ideas anyone? Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using multiple sheets from a workbook in a formula
What do you mean by 'doesnt seem to be working'? what is your formula?
"Megglesface" wrote in message ... If I want to use a cell value in a formula, but the cell is from another worksheet in the same book, how do I do this? I thought I just entered = into the formula box then clicked onto the other worksheet and selected the cell, but that doesnt seem to be working, any ideas anyone? Thanks. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using multiple sheets from a workbook in a formula
well if the cell I want the formula in is A1 on sheet2, and the cell I want
to use as part of my formula is B1 on sheet1, then how can i make this into a formula? If I click on B1 then it brings up the wrong cell reference in my formula field. "Gaurav" wrote: What do you mean by 'doesnt seem to be working'? what is your formula? "Megglesface" wrote in message ... If I want to use a cell value in a formula, but the cell is from another worksheet in the same book, how do I do this? I thought I just entered = into the formula box then clicked onto the other worksheet and selected the cell, but that doesnt seem to be working, any ideas anyone? Thanks. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using multiple sheets from a workbook in a formula
Perhaps you couldn't read what Gaurav asked:
"what is your formula?" -- David Biddulph "Megglesface" wrote in message ... well if the cell I want the formula in is A1 on sheet2, and the cell I want to use as part of my formula is B1 on sheet1, then how can i make this into a formula? If I click on B1 then it brings up the wrong cell reference in my formula field. "Gaurav" wrote: What do you mean by 'doesnt seem to be working'? what is your formula? "Megglesface" wrote in message ... If I want to use a cell value in a formula, but the cell is from another worksheet in the same book, how do I do this? I thought I just entered = into the formula box then clicked onto the other worksheet and selected the cell, but that doesnt seem to be working, any ideas anyone? Thanks. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using multiple sheets from a workbook in a formula
Type the = sign, switch to other sheet, select a cell then hit ENTER key.
Gord Dibben MS Excel MVP On Wed, 7 May 2008 05:49:00 -0700, Megglesface wrote: If I want to use a cell value in a formula, but the cell is from another worksheet in the same book, how do I do this? I thought I just entered = into the formula box then clicked onto the other worksheet and selected the cell, but that doesnt seem to be working, any ideas anyone? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automated multiple text files into multiple sheets in one workbook | Excel Discussion (Misc queries) | |||
Viewing Multiple Sheets from Same Workbook | Excel Discussion (Misc queries) | |||
Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
How to create workbook with multiple sheets | Excel Discussion (Misc queries) | |||
Use the same name on multiple sheets in same workbook | Excel Discussion (Misc queries) |