Another solution to matching data on two worksheets is the Multiple Consolidation Ranges option in the pivot table. Unfortunately, it is much harder to find ...
Keywords for this video: accounting, business, excel, mrexcel, pivot, spreadsheets, table, technology, tutorial
This video is current as of January 14, 2009
For more resources for Microsoft Excel: