Excel 2007 Resource Center

MVP Ron de Bruin provides a number of samples to merge data from multiple worksheets into one summary worksheet. After you have all the data on one worksheet, you can do things such as build a PivotTable report based on your specific criteria or use the filter options in Excel 2007 to get the results you want.

Frank Rice shows how to create a simple project in Excel 2007 that allows you to import your Zune music playlist into a worksheet by using XML and XPath.