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?