Pivot from all sheets

  • Thread starter Radhakant Panigrahi
  • Start date
R

Radhakant Panigrahi

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dates In Excel 5
Doughnut Chart linked with the slicer in the pivot table 0
Dealing with a Pivot Table (when I don't want to) 0
Need Help with a VBA subroutine 0
Excel does not accept text format! 0
sumproduct of multiple sheets 5
Formula to Look up values from a pivot table 1
Extened Pivot 1

Top