Hey guys, I do not know if we can do this in excel... if it is possible, can you teach me how to ? here is a situation.

I keep a log of my expenses in excel. Column A has date on it. There will be multiple entries in one date, for instance, row 2,3,4 used today. Column B has the field I spend the money in, like, transportation, breakfast, lunch, pizza, chinese food, cigarette, and such. I did not assign a column to these items (to enter the values only in the corresponding columns) because I spend money in too many different things, so I thought it would be better if I write the name itself. Column C has the price for each field in column B.

Now I want to create a new sheet in the same file  to narrow down the cost of one field.. like say coffee cost. Is it possible to selectively pull the data from the first sheet to the second one? for instance, the third entry for today's date is $2.00 for coffee. I enter 4/21/2009 in Column A, Coffee in Column B and Column C has $2.00. No coffee was purchased yesterday but was the first entry on day before yesterday. In the separate sheet, I want to (I wish i could) compile the expenses on coffee only for the month. If possible, the second sheet would have different dates in Column A, 'coffee' in Column B and its cost in Column C.

If anybody knows how to do it, or if anybody knows if it is NOT possible to do it in excel, ..can you please share..... thanks