Prev: File set up query.
Next: Unprotecting what Excel says is unprotected ???
From: Radhakant Panigrahi on 6 May 2010 01:23
Hi,
Can anybody help me. I have 25 sheets with same no of column and in the same
sequence. I need to make pivot using column A, B , and Cas range taking all
the data from 25 sheets...if copy all the data from 25 sheets, paste in a
single sheet and make pivot then it takes a long time and more over some
times the data exceeds 65000 lines for a single sheet....

Can anybody please help me out to resolve my query and whether it is posible
to make pivot using the data from multiple sheet as range...
From: Jacob Skaria on 6 May 2010 01:45
Check out
http://www.contextures.com/xlPivot08.html

--
Jacob (MVP - Excel)


"Radhakant Panigrahi" wrote:

> Hi,
> Can anybody help me. I have 25 sheets with same no of column and in the same
> sequence. I need to make pivot using column A, B , and Cas range taking all
> the data from 25 sheets...if copy all the data from 25 sheets, paste in a
> single sheet and make pivot then it takes a long time and more over some
> times the data exceeds 65000 lines for a single sheet....
>
> Can anybody please help me out to resolve my query and whether it is posible
> to make pivot using the data from multiple sheet as range...
 | 
Pages: 1
Prev: File set up query.
Next: Unprotecting what Excel says is unprotected ???