Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
One pivot table for multiple worksheets/tabs
Hi there
Just a quick one pivot tables. Say I have multiple worksheets all with 35k lines or so, all with the same headings and data formats, is it possible to create a pivot table that looks at all four tabs and sums them into one table on one worksheet? Thanks Mike |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
One pivot table for multiple worksheets/tabs
Debra Dalgleish shows how he
http://contextures.com/xlPivot08.html Me? I've always copy|pasted to a new worksheet that held all the data. mike_vr wrote: Hi there Just a quick one pivot tables. Say I have multiple worksheets all with 35k lines or so, all with the same headings and data formats, is it possible to create a pivot table that looks at all four tabs and sums them into one table on one worksheet? Thanks Mike -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
One pivot table for multiple worksheets/tabs
Hi Mike
Unless you have XL2007, you won't be able to append sheets with 35K lines, as 70K would be above the XL2003 limit of 65536 rows. You could export the data as from each sheet as csv files. Join all 4 sheets together with a DOS command, or CopyPaste into Wordpad to join them all together. Then change the file extension to .txt. Then in XL2003, you could use External Data source, and point at your large txt file. -- Regards Roger Govier mike_vr wrote: Hi there Just a quick one pivot tables. Say I have multiple worksheets all with 35k lines or so, all with the same headings and data formats, is it possible to create a pivot table that looks at all four tabs and sums them into one table on one worksheet? Thanks Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot table for multiple worksheets | Excel Worksheet Functions | |||
pivot table and multiple worksheets | Excel Discussion (Misc queries) | |||
Pivot Table with multiple worksheets | Excel Discussion (Misc queries) | |||
Pivot Table - Multiple Worksheets | Excel Discussion (Misc queries) | |||
Pivot table from multiple worksheets . . . possible? | Excel Discussion (Misc queries) |