[Solved] Taking data from one sheet to another automatically

Discuss the spreadsheet application

[Solved] Taking data from one sheet to another automatically

Postby oleingva » Mon Jan 28, 2008 11:58 pm

Hi all,

I've tried searching the help file, the tutorials and the FAQ, but it is so hard to find something when you have no idea what terms to use to search for it . . .

What I want to do is this: I have two separate sheets in my spreadsheet. In the first one, I have month-to-month expenses and incomes, in the other one I have a total for each post on the budget. Like this:

Sheet 1:

May
1 Membership fee 100,-
2 Membership fee 100,-
3 Office supplies -231,-
4 Membership fee 100,-
5 Donation 1000,-
6 Car rental -1100,-
7 Donation 100,-
8 Tractor rental -500,-
etc.

Sheet 2:
Incomes:
1 Membership fees 300,-
2 Donations 1100,-

Expenses:
3 Transportation -1100,-
4 Office expenses -231,-
5 Building expenses -500,-
etc.

Now I want sheet 2 to automatically look up sheet 1, get all relevant posts there, and add them together in the right post in sheet two. Alternatively, I want to be able to label each post in sheet 1 so that the data moves to the right post in sheet two, and is added together there. I.e., for this example, post 1 in sheet 2 adds up posts 1, 2 and 4 in sheet 1; post 2 in sheet 2 adds up posts 5 and 7 in sheet 1 and so on.

Also, I want it to be reusable and as quick to use as possible. Can this be done? If yes, how?
Last edited by oleingva on Fri Feb 01, 2008 1:00 pm, edited 1 time in total.
oleingva
 
Posts: 2
Joined: Mon Jan 28, 2008 11:44 pm

Re: Taking data from one sheet to another, automatically

Postby kingfisher » Tue Jan 29, 2008 2:39 am

I think the SUMPRODUCT function will do what you want. You could also look at SUMIF.
OpenOffice 3.3 on PCLinuxOS. There are 3 kinds of people: those who can count and those who can't.
User avatar
kingfisher
Volunteer
 
Posts: 1861
Joined: Tue Nov 20, 2007 10:53 am

Re: Taking data from one sheet to another, automatically

Postby oleingva » Fri Feb 01, 2008 1:00 pm

SUMIF does the trick. Thank you very much for your help!
oleingva
 
Posts: 2
Joined: Mon Jan 28, 2008 11:44 pm


Return to Calc

Who is online

Users browsing this forum: mtahoon and 19 guests