Please help me to solve auto-scan of worksheet

  • Thread starter Thread starter gilbert
  • Start date Start date
G

gilbert

Hi Excel experts,

I am Excel newbie......and there are lots of catchup for me to do.
Currently I am trying to create a simple workbook to capture my daily
expenses. In one worksheet, I will create 5 rows x 2 columns boxes,
tabled it within the shortest range possible.

These boxes will eventually be keyed in with the expenses I spent daily
on food, traveling, petrol and etc (the expenses not fixed). For
example, In box no. 1 :-

Food - $10
Traveling - $5
Magazine - $3
Total - $18

In box no. 2, I've the followings :-

Food - $12
Petrol - $10
Traveling - $3
Magazine - $3
Total - $28

And these expenses go on and on for the whole month with food repeating
basically in all boxes.

My question is can I create another worksheet within the same workbook
whereby it will help me to scan thru the expenses worksheet and list
out all the expenses by category in date sequence in the new worksheet
just created. To illustrate :-

_Food_
box 1 - $10
box 2 - $12
box 3 - $ 5 (not in abv example)
box 4 - $ 8 (not in abv example)

Is there any simple Excel formulation that can do that without using
VBA? I have zero knowledge on VBA....Please help

Thank you in advance.

Best regards,
Gilbert
 
1. Make sure to add ALL your data to the SAME list with fields:
for example:
Date Category Expense
12-Jan-04 Food 12.45

2. Sort your list based on the Category field to get all the same categories
grouped together

3. Open the Data menu, and use the Subtotals command to subtotal the
Expenses at each change in Category.

There you have it! All without a macro

TTFN
JMMach, MCSC
 
Back
Top