VLOOKUP? Filter? Best way to populate multiple cells automatically....

[Fredzilla]

I'm not sure the best way to tackle this. I've got a sheet with miscellaneous expenses on it including: Date | Amount | Description | Name

I'm wondering if it's possible to have another sheet (expense report) that would auto-populate by providing Name and date range.

[teylyn]

You can use a pivot table to report on the data.

To get started with Pivot Tables, check out http://peltiertech.com/Excel/Pivots/pivotstart.htm