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 |
All times are GMT +1. The time now is 04:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com