Pivot from all sheets

  • Thread starter Radhakant Panigrahi
  • Start date


Radhakant Panigrahi

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