Pivot Table Question

[Guest]

I have a question regarding the data range used to create a pivot table. Can
I use data on two different tabs of my workbook to create the pivot table.
For example, the data will come from Sheet1$A$1:$L$30000 and
Sheet2$A$1:$L$45000. I have an export of a full years worth of transactions
totaling around 75,000 rows broken apart on two tabs. The columns of
information are the same on both tabs.

Is this possible and if so how would I go about doing this?

Thanks

 

[Debra Dalgleish]

You can create a pivot table from data on separate sheets (multiple
consolidation ranges), but the results may not be exactly what you want.
There's more information here:

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

 

[Guest]

Thanks for getting back Debra, you have been a great help on expanding my
knowledge of Pivot Tables and Excel.

I actually put my data into an Access DB and used that to create my pivot
table.

Thanks again.

 

[Debra Dalgleish]

You're welcome. Thanks for describing how you solved the problem.