Browse » Home
Sunday, April 17, 2011
How to Create a Pivot Table From Multiple Sheets
1. Open the Excel workbook that has the worksheets you want to use to create a Pivot Table. Click a blank cell that you aren't using in the Pivot Table report.
2. Start the Pivot Table and Pivot Chart Wizard by pressing the following keys 'ALT' 'D' 'P.' The Pivot Table and Pivot Chart Wizard box will open.
3. Check the box next to 'Multiple consolidation ranges' under the question that asks 'What is the data that you want to analyze?'
4. Check the box next to 'Pivot Table' when asked what type of report you want to create; click 'Next.'
5. Check the box next to 'I will create the page fields' and click 'Next.'
6. Select the ranges of data you want to use to create the Pivot Table. For example, click 'Sheet 1' and use your mouse to highlight the data you want to use from that sheet. After you select a range of data, click 'Add.' Select the next sheet you want to use data from and highlight the data and click 'Add.' Repeat this for each sheet that has data you want to use.
7. Check the box next to the number of page fields you want when you are asked how many page fields you want on the Pivot Table.
8. Enter an item label for each page field you chose to add and click 'Next.'
9. Decide whether you want to add the Pivot Table to a new or existing worksheet and click 'Finish.' The Pivot Table will open and you can begin manipulating the data.