If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
pivot table using very large dataset
Hi - I'm trying to set up a pivot table with a very large
dataset. I've got 110 Excel worksheets broken into 2 workbooks. Each worksheet consists of about 5 columns of data and an average of perhaps 7,000 rows. So we're talking quite a few rows of data, total. Can I use multiple consolidation ranges to correlate the information in these worksheets? I don't need to do any fancy calculations, just a lot of filtering, summing, and comparing. Do I need to provide more information about the particular application? Thanks much. |
Thread Tools | |
Display Modes | |
|
|