Excel Worksheets

D

Deb

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?
 
J

JLatham

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

trip_to_tokyo

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

Deb

Thanks so much, this worked perfect!

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

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