MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Auto Filter, Pivot Table, or What?

Posted by Michael on January 15, 2002 6:55 AM

I have two sheets in a budget:

First - has a listing of everything I spend. The column headings are date, category, description, amount

Second - is a report I want to create where I enter into A4 the month and into A6 the category of expense. What I want to appear below are all the expenses for that month for that category of expense. The example is I put January and Meals in A4 & A6 and below appears in rows the date, category(meals in this case), description and amount just as it is in sheet one.

Is this possible? How can I do it?

Posted by Barrie Davidson on January 15, 2002 6:58 AM

See 15218.html (nt)