Creating a pivot table from tables in 10 different workseets

**thedizzyblonde100** · 05-01-2014, 08:31 AM

Hello,

I am using EXCEL 2013 and am attempting to consolidate data from a specific worksheet in 10 different worksheets.

I know how to create table sand create a pivot table from these tables when they are in the one worksheet but was wondering if anybody knew a way of getting the data from the other worksheets into the one workbook initially (or a better way altogether!)

My VBA is limited although I am unsure whether this is necessary here. I know that previous versions of excel had a multiple consolidation tab the pivot table wizard though I never used it. The Excel 2013 does not seem to have this option.

Any help would be much appreciated!

**romperstomper** · 05-01-2014, 08:37 AM

Are these worksheets in the same workbook, or different workbooks?

Pivot tables made from consolidation ranges (which should still be available in 2013 as best I recall) are limited in their functionality, so I would suggest consolidating the data into one table first and then creating the pivot table off that, or you can use code to actually load the data into a recordset and assign that to the pivot table without actually creating a new source data table first. The former is simpler though.

Creating a pivot table from tables in 10 different workseets

LinkBack

Thread Tools

Rate This Thread

Display

Creating a pivot table from tables in 10 different workseets

Re: Creating a pivot table from tables in 10 different workseets

Thread Information

Users Browsing this Thread

Similar Threads

Creating a Master / Consolidated Pivot Tables from a multiple pivot tables

Creating a Master / Consolidated Pivot Tables from a multiple pivot tables

Creating data tables from a database without using pivot tables

Creating Multiple Pivot tables

Creating Pivot Tables

Bookmarks

Bookmarks

Posting Permissions