View Single Post
  #1   Report Post  
Tobias Gårdner
 
Posts: n/a
Default 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