[Solved] Taking data from one sheet to another automatically
Posted: 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?
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?