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


---
Message posted from http://www.ExcelForum.com/