How do I combine worksheets w/o enough rows to combine?
 

How do I combine 2 worksheets in the same workbook, so that I can create a
pivot chart? The only problem I have is that if I try to manually combine
the two worksheets, I don't have enough rows.

How do I combine worksheets w/o enough rows to combine?
 

Amanda

You can create a pivot table with data in 2 worksheets; provided both are in
the same format. From the pivot table window checkout 'Multiple
consolidation of ranges'

If this post helps click Yes
---------------
Jacob Skaria


"Amanda W." wrote:

How do I combine 2 worksheets in the same workbook, so that I can create a
pivot chart? The only problem I have is that if I try to manually combine
the two worksheets, I don't have enough rows.

How do I combine worksheets w/o enough rows to combine?
 

You can create a pivot table from data on different worksheets, using
Multiple Consolidation Ranges, but the results might not be acceptable
to you.

There's information here, and suggested workaround to the limitations:

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

Amanda W. wrote:
How do I combine 2 worksheets in the same workbook, so that I can create a
pivot chart? The only problem I have is that if I try to manually combine
the two worksheets, I don't have enough rows.


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com

How do I combine worksheets w/o enough rows to combine?
 

Hi,

1. You can create a pivot table from two or more ranges by using a Union
Query, which may overcome the problems of using multiple consolidation
ranges, but its pretty tricky.

2. A second alternative is to use Access, with or without Excel.

If you tell us more about your data and the pivot table you want we might be
able to pin down the best solution.
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Amanda W." wrote:

How do I combine 2 worksheets in the same workbook, so that I can create a
pivot chart? The only problem I have is that if I try to manually combine
the two worksheets, I don't have enough rows.