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

Advertisements


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

Top