I need to create a Pivot Table using data that is in multiple sheets. Each sheet has sales data for a particular year and all the columns in the sheets have the same Header Names. How do I do this? Please help!
Pivot Table from Multiple Sheets in Excel 2010(3 posts) (3 voices)
you should create one Main WorkSheet; import the various data in different Tabs (different years - easiest way for maintenance) Then put the data in one large sheet (#2 after #1 etc.) and then create your pivot. Later on, if you are familiar with this workaround you can import directly from different files of course.
Maybe you want to create extra colums in the Main sheet for data manipulation; that shoud be easy too.
You may send me a small example if you need further help, firstname.lastname@example.org
All the Columns have the same Header names in all the sheets.
Select Data - Pivot Table/Pivot Chart (For Excel 2007 press Alt + D + P)
In Pivot Table wizard window - Select Multiple Consolidation Ranges - Next
Select First Option - Create a single page field for me.
Now In Range - Select the data in the first sheet for which pivot is required then Click Add.
Then sleect the second sheet range & agian click add. In this way select all the data in the various sheet for which Pivot is required & after you have added all the ranges. Press Next & Finish.
In case this is not what you are looking for, please elaborate your question.
You must log in to post.