Debra, thanks so much for pointing me to the right place at your site. The
Union query example was right on target for me. Your site is an excellent
resource.

Thanks again,
Steve


"Debra Dalgleish" wrote:

You can use a Union query to combine the data from the ranges. There's a
sample he

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

Under PivotTables, look for PT0007 - Multiple Consolidation Ranges

Steve Vincent wrote:
Hello,

I know this question has been posted, but I will ask again: Can I create a
Pivot Table from two separate data ranges, e.g., different months' data on
different sheets? The data are laid out identically, i.e., same column
headings, same number of columns. Just different rows/records.

I have already scoured the postings on this topic and have tried the
solutions offered, and (1) consolidation doesn't give me useful results, and
(2) creating a MS Query doesn't work because the two ranges in question are
not joined or linked by a common field, but are actually two sets of
identically-laid-out data.

Is there actually no way to select-to-combine two non-adjacent ranges/lists
in a workbook to combine into one Pivot Table?

Thanks in advance for any advice you can offer,

Steve



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