Pivot Table Question

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 here:

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 here:
>
> 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 here:
>>
>> 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