Consolidation of Multiple worksheets

hedgie

Board Regular
Joined
Jun 23, 2004
Messages
164
I have a very data intensive workbook. There are data sheets for each of the months of the year. Each sheet has 19 columns of data with 10,000 to 12,000 rows. THe columns are identical across each sheet. I want to consolidate the data into a pivot table that would sum the entire years worth of data. I have already successfully created a pivot table on a single month which accurately sums that months worth of data. The problem is the quantity of the data. Anyone have a suggestion on how to best handle this? Using the multiple worksheet option to consolidate in a pivot table has the computer hanging even if I only try January and February together. I am certain the entire year is out of the question by that methodology. (For the record I have named each months data range to include the columns ($A..$S) - so blank rows are included.)

Any thoughts?
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

KenoshaCanuck

New Member
Joined
Dec 29, 2004
Messages
10
Have you thought of importing your Excel worksheets into Access, and combining them via a query/join. You can then export your newly created query file into an Excel pivot table for manipulation as needed. Just a thought, though I'm sure there are other ways to accomplish your task.
 

Forum statistics

Threads
1,148,228
Messages
5,745,482
Members
423,953
Latest member
MrC54

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top