I had to create a pretend budget, which I did. I had to enter the total
annual revenue and total annual expenses. Now on the second sheet, I have to
enter the same info..
Now my questions is what formula do I need to pull totals from one sheet to
another.. I need to know how to do this step by step please.. thank you

click onto a cell on the "other" sheet and enter =
go back to the "one" sheet where the total is and click onto that cell
the cell will get the dashed live border ...just press enter

the cell om the other sheet will now display the total
it will have a formula like.... =sheetone!C24
if the total is in C24

--
Greetings from New Zealand


"proudmomof2" wrote in message
...
I had to create a pretend budget, which I did. I had to enter the total
annual revenue and total annual expenses. Now on the second sheet, I have
to
enter the same info..
Now my questions is what formula do I need to pull totals from one sheet
to
another.. I need to know how to do this step by step please.. thank you

On Mar 10, 3:02 pm, proudmomof2
wrote:
I had to create a pretend budget, which I did. I had to enter the total
annual revenue and total annual expenses. Now on the second sheet, I have to
enter the same info..
Now my questions is what formula do I need to pull totals from one sheet to
another.. I need to know how to do this step by step please.. thank you

Well, the syntax for the cell reference would be sheetName!
cellReference. For example, Sheet1!A1. But arguably, the easiest way
(least prone to typos) to do this is: while entering a formula in the
second sheet, where you want to reference a cell in the first sheet,
simply left-click the first-sheet tab on the bottom of the frame and
left-click the desired cell or select the desired range on the first
sheet. Then continue typing the formula. You might want to left-
click the second-sheet tab to go back to it. This will happen
automatically when you press Enter to commit the formula.

We don't do homework...

But I'll make an exception <g since this is pretty much a "how to" thing,
and proud mom's of two are probably busy with other things also!

Go to the second sheet, select the cell where you want the value from the
first sheet to show up at, enter the = symbol to start a formula, choose
the first sheet again, click the cell you want to 'echo' on the second sheet
and then press the [Enter] key.

Basically you can treat cells in other worksheets just like you do cells on
the same worksheet - you just have to bounce around the workbook a bit to do
it, and you have to know when to go to the other sheets, when to make an
entry from your keyboard and when to hit the [Enter] key.

Now, after you've done that, look at the formula created, it will probably
look something like this:
='My Budget'!A1
and that should give you a clue that you can enter such formulas by simply
preceding the cell address with the sheet name they are on. Note that if a
sheet name contains spaces, you must surround the sheet name with the single
quote marks. If the sheet name doesn't have spaces, the formula will survive
without them.

This logic of this process can even be extended to cells in other workbooks.

"proudmomof2" wrote:

I had to create a pretend budget, which I did. I had to enter the total
annual revenue and total annual expenses. Now on the second sheet, I have to
enter the same info..
Now my questions is what formula do I need to pull totals from one sheet to
another.. I need to know how to do this step by step please.. thank you

Assuming the total annual revenue is in A45 of Sheet1.

In sheet2 in any cell =Sheet1!A45

Same for annual expenses.

This is called "linking". See help for more on linking.


Gord Dibben MS Excel MVP

On Sat, 10 Mar 2007 15:02:06 -0800, proudmomof2
wrote:

I had to create a pretend budget, which I did. I had to enter the total
annual revenue and total annual expenses. Now on the second sheet, I have to
enter the same info..
Now my questions is what formula do I need to pull totals from one sheet to
another.. I need to know how to do this step by step please.. thank you