Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro does not run when data refreshed | Excel Discussion (Misc queries) | |||
how do I make a copy of a worksheet and retain formulas but not data | Setting up and Configuration of Excel | |||
Copy data into a NEW worksheet | Excel Discussion (Misc queries) | |||
use data on master worksheet for sorting | New Users to Excel | |||
Reference Data in Moved Worksheet | Setting up and Configuration of Excel |