Please help me to solve auto-scan of worksheet
 

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/

Please help me to solve auto-scan of worksheet
 

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
"gilbert " wrote in message
...
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/

Please help me to solve auto-scan of worksheet
 

I think you got my idea wrong...to illustrate my idea, maybe u can just
take a look at the "test" workbook that I just created.

Please help me to solve the problem faced.

Thank you in advance.

Rgds,
Gilbert

Attachment filename: test.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=405564
---
Message posted from http://www.ExcelForum.com/