Report on data in work***?
From: Tobias Gårdner (tobias.gardner_at_ericsson.com)
Date: 10/28/04
- Next message: Pam Coleman: "vlookup"
- Previous message: Mcasteel: "VBA: Return Searched Value Inputed by End-User"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 28 Oct 2004 14:45:07 +0200
Hi,
I would like to set up a personal economy overview... The input data looks
like:
- reoccuring expenses, i.e per month, per quarter etc
- expenses for a particular month, e.g. car repair
The first data consists of a table looking like this:
Jan Feb March April
...
Food $5 $5 $5 $5
Rent $10 $10 $10 $10
Phone $3 $3
Insur. $2 $2
...
The second chunk of data is per month, e.g.
January
car repair $20
book order $5
Feburary
clothes $10
March
misc $5
...
What I would like is a report that consolidates the information. Looking at
e.g. Februrary the output would be:
Feburary
Food $5
Rent $10
clothes $10
Is this doable in Excel or do I need to create a database for this?
Best regards,
Tobbe G
- Next message: Pam Coleman: "vlookup"
- Previous message: Mcasteel: "VBA: Return Searched Value Inputed by End-User"
- Messages sorted by: [ date ] [ thread ]