Topic: Excel Problem

[Eva Ann]

Can someone help me with transferring totals automatically from one spreadsheet to another without using Copy and Paste.
I do a budget and would like my monthly totals to automatically go to the annual totals on a separate sheet.
I have Windows 2000 ME.
Eva Ann

[Adept]

In the second sheet, select the cell that you wish the total to go into.

Then press =

Click the Tab for the first sheet

Click the cell containing the total you wish to use

Press Enter

The cell on the second sheet will now contain a formula similar to =Sheet1!A5

Repeat for any other totals required.

[Simon]

That's bloody brilliant, Sean!  I've been wondering how to do that for years!  

 Eva Ann, and thanks for asking!  

[Simon]

Next question, how do you open a document as a new sheet?    If I open my first sheet, then open another, it still comes up as sheet 1, but I want them as sheet 1 and sheet 2.

[Rodders]

If you want them as different sheets in the same workbook, simply right-click on the tab at the bottom of the sheet and select 'Move or Copy'.  Make sure you have 'Create a Copy' ticked.  You can also rename them by right-clicking on the tab, if necessary.  Hope this works helps.

[Eva Ann]

Thank you, thank you, thank you! Eva Ann dancing cheerfully in New Zealand

[Eva Ann]

In the second sheet, select the cell that you wish the total to go into.

Then press =

Click the Tab for the first sheet

Click the cell containing the total you wish to use

Press Enter

The cell on the second sheet will now contain a formula similar to =Sheet1!A5

Repeat for any other totals required.

There I go again :-[ (I put my thank-you message in the wrong place) but I think I am finding my way around the site at last. :)One very happy Kiwi here.

[Simon]

It still isn't really doing what I want, which is this:

I calculate my weekly accounts with a simple income / expenses ledger, and I have a separate summary ledger, with the weekly net amounts in one column, with the correponding date in another column.  I have to input the date manually, but I want the weekly total in the weekly sheet to appear automatically in the correct cell in the summary sheet.  Example below:

01/01/04  £xxx.xx
08/01/04  £xxx.xx

So each weekly total would need to appear underneath the previous weeks total.  I can do it easily enough by copy and pasting, but like Eva Ann, I would like it to be automated.

[Tony]

WELL I asked the following question before, but got no answer > is it coz I'm not a cute girlie from NZ  

Right using MS XP Office Pro

If I have say two or more spreadsheets open, they are only viewable   one at a time in the same open window. Now because I have three monitors on my system, I would like to be able to view them all at once, in its own window on a seperate  monitor.

I tried, what you advised Rodders, but to no avail.

I would be interested to know if this is do able, because I'm sure it was in earlier MS office programs.

But it is all academic really, as because I never got it sorted, I downloaded
the "free" Open Office suite of programs from HERE

And I'm pleased I did as the Spreadsheets do just that, open in their own windows, plus I find the " mathmatical equations" mechanism easier to work with, than the MS one.

Put it this way, I have some friends who run their own business, and use spreadsheets. Anyway I was setting their new PC up for them [one of my made to measure models  ] Whist I was at their house, I found out that they called one of their daughters over to set the "formula" for them. Yes she had shown them how to do it time and again BUT.

Anyway....to make a short story longer   I installed Open Office on their PC as well as XP Office. During the Open Office install I ticked the "open all spreadsheets in Open Office " box. Showed them twice how to use the "forumula" and they are happy as Larry.

Just to round of, Eva I recieved a PM from your goodself, and judging from the content I very much doubt it was ment for me. And in anycase I'm not sure I can maintain that position on one leg, whilst at the same time supporting the whole weight of your body  

[Simon]

I remember you asking that question Tony.  Obviously nobody knew how to do it, unless it's not possible with MS Office.  I'm fairly certain that what I am asking is[/b] possible - I just haven't the brains to sort it out!  

[Adept]

So each weekly total would need to appear underneath the previous weeks total.  I can do it easily enough by copy and pasting, but like Eva Ann, I would like it to be automated.

Sounds like you need a PivotTable Simon.

Insert a PivotTable into your sheet and select the range(s) of the summary ledger. Take all the automatic options in the wizard.

Once the PivotTable displays, right click the date from the first data item and choose Group and Show Detail, Group and select Months. This will then summarise the months for you automatically.

[Simon]

Thanks Sean, I'll look into that.