View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bill Kuunders Bill Kuunders is offline
external usenet poster
 
Posts: 303
Default Have a question on a homework thing I have using excell

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