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

  • Thread starter Thread starter Amanda W.
  • Start date Start date
A

Amanda W.

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.
 
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
 
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.
 
Back
Top