LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 28th 04, 01:45 PM
Tobias Gårdner
Posts: n/a
Default Report on data in worksheet?


I would like to set up a personal economy overview... The input data looks
- 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.
car repair $20
book order $5
clothes $10
misc $5

What I would like is a report that consolidates the information. Looking at
e.g. Februrary the output would be:
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
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 07:29 AM.

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

About Us

"It's about Microsoft Excel"


Copyright © 2017