Merge 2 datasheets into single Pivot Table.

[free_ur_mind]

I use Excel 2003.

In a single Excel File, I have similar data in 2 different worksheets & I
need to combine them in a single Pivot Table. I cannot paste them one below
the other as the data is more than 65536 lines, so I split them into 2
sheets.

Is there a way to get these data in a single Pivot Table....

 

[Shane Devenshire]

Hi,

1. I prefer the concept of storing the data in Access and connecting an
Excel pivot table to the data.

2. Also a nice solution would be to upgrade to Excel 2007 which allows
1,048,000+ rows per sheet.

3. Depending on exactly what you are trying to do and your data layout you
could try the Data, PivotTable and PivotChart Report command and choose
Multiple Consolidate Ranges.

4. The most difficult would be to use a Union query.

 

[Eduardo]

Hi,
Look into Debra Web

http://www.contextures.com/xlPivot08.html

if this helps please click yes, thanks