Report on data in worksheet?
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
|