Archive of Mr Excel Message BoardArchive of Mr Excel Message Board
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?
Have you tried using a pivot table? If you drag a field button to the "Page" area of the pivot table you, in effect, get drop down boxes where you can select your parameters (Note - you can only select one, or all, data point(s) for each field; you can't select two).
Regards,
BarrieBarrie Davidson