| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot from all sheets
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... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot from all sheets
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... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Sheets / Pivot | Excel Worksheet Functions | |||
| Pivot for multiple sheets | Excel Discussion (Misc queries) | |||
| Pivot from multiple sheets // | Excel Discussion (Misc queries) | |||
| Pivot Data- Pivot on multiple sheets | Excel Discussion (Misc queries) | |||
| pivot table to sheets | Excel Worksheet Functions | |||
Linear Mode
