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

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 he

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


MarkM wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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" wrote:

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 he

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


MarkM wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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

MarkM wrote:
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" wrote:


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 he

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


MarkM wrote:

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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html