Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro does not run when data refreshed Larry Lehman Excel Discussion (Misc queries) 0 January 16th 05 07:31 PM
how do I make a copy of a worksheet and retain formulas but not data FireBrick Setting up and Configuration of Excel 2 December 29th 04 07:33 PM
Copy data into a NEW worksheet Krefty Excel Discussion (Misc queries) 1 December 22nd 04 01:53 PM
use data on master worksheet for sorting Ken New Users to Excel 1 December 7th 04 03:30 AM
Reference Data in Moved Worksheet tommcbrny Setting up and Configuration of Excel 1 December 1st 04 06:49 PM


All times are GMT +1. The time now is 01:51 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"