Archive of Mr Excel Message Board


Back to Pivot Tables in Excel archive index
Back to archive home

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?


See 15218.html (nt)

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


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.