Crazy Problem Extracting Data From a Filter


Posted by Michael on January 14, 2002 5:46 PM

I have two sheets in a budget:

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

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

Is this possible? How can I do it?



Posted by Richard S on January 14, 2002 10:19 PM

Have you tried Autofilter? (nt)