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.