Title:
How to Create an Excel Pivot Table from Multiple Sheets
Video:
Description:www.contextures.com If Excel data is on different sheets, you can create a pivot table using multiple consolidation ranges. This video shows you the steps in Excel 2007, to create the pivot table and set up page fields. To create a regular pivot table from data on multiple sheets, you can use a macro that creates a union query from all the data. There is a sample file to download at blog.contextures.com
Published:
15/Apr/2010
How to Create an Excel Pivot Table from Multiple Sheets
Video:
Description:www.contextures.com If Excel data is on different sheets, you can create a pivot table using multiple consolidation ranges. This video shows you the steps in Excel 2007, to create the pivot table and set up page fields. To create a regular pivot table from data on multiple sheets, you can use a macro that creates a union query from all the data. There is a sample file to download at blog.contextures.com
Published:
15/Apr/2010
No comments:
Post a Comment