Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Worksheets
I want to set up 2 different worksheets in one document (workbook), and I
want to bring a formula based cell from the first worksheet to be included in a formula in a second worksheet. How do I do that? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Worksheets
Just refer to it in your formula as you would any cell on the same sheet, but
include the sheet name with it, as: =A1 + Sheet1!A1 + B2 or =A1 + 'Sheet Name Has Spaces'!A1 + B2 You can even have Excel do all the typing for you: go ahead and start your formula and when you need to refer to an off-sheet (or even different workbook) cell, select that (workbook) worksheet and cell and then continue writing your formula. So in the 1st example above I could have typed =A1 + and then selected Sheet1 and cell A1 on it and after doing that, continued typing the " + B2" end of the formula. "Deb" wrote: I want to set up 2 different worksheets in one document (workbook), and I want to bring a formula based cell from the first worksheet to be included in a formula in a second worksheet. How do I do that? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Worksheets
EXCEL 2007
Hi Deb, I am not 100% clear on your question but here goes anyway in the hope that what I have said is right. 1. In Sheet1 I have:- - the number 1 in cell A1 - the number 2 in cell B1 - the following formula in cell C1:- =(A1+B1) This returns the result of 3 in cell C1 (and this is correct). 2. I am now going to copy the formula in cell C1 above (Sheet1) to cell C1 of Sheet2. This is what I do:- - with the cursor in cell C1 (Sheet1) Ctrl-C to copy - click in Sheet2 cell C1 / Home / Clipboard group / Paste / Formulas 3. Cell C1 of Sheet 2 will now contain:- =(A1+B1) 4. You can test that Sheet2 works OK (the formula in cell C1) by entering values in cells A1 and B1 (of Sheet2). If my comments have helped please hit Yes. Thanks. "Deb" wrote: I want to set up 2 different worksheets in one document (workbook), and I want to bring a formula based cell from the first worksheet to be included in a formula in a second worksheet. How do I do that? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Worksheets
Thanks so much, this worked perfect!
"JLatham" wrote: Just refer to it in your formula as you would any cell on the same sheet, but include the sheet name with it, as: =A1 + Sheet1!A1 + B2 or =A1 + 'Sheet Name Has Spaces'!A1 + B2 You can even have Excel do all the typing for you: go ahead and start your formula and when you need to refer to an off-sheet (or even different workbook) cell, select that (workbook) worksheet and cell and then continue writing your formula. So in the 1st example above I could have typed =A1 + and then selected Sheet1 and cell A1 on it and after doing that, continued typing the " + B2" end of the formula. "Deb" wrote: I want to set up 2 different worksheets in one document (workbook), and I want to bring a formula based cell from the first worksheet to be included in a formula in a second worksheet. How do I do that? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to save modified Excel 2003 worksheets using Excel 2007 | Excel Discussion (Misc queries) | |||
How use info in Excel shared worksheets to create new worksheets | Excel Worksheet Functions | |||
How do i assign the ActiveWorkbook.Worksheets to a worksheets object? | Excel Worksheet Functions | |||
Weird problem with Excel 2000...Worksheets disappearing in a shared Excel file | Excel Discussion (Misc queries) | |||
Assigning Cells in worksheets to other data in other worksheets. | Excel Discussion (Misc queries) |