pivot table
how do I do a pivot table with data that is on multiple worksheets?
|
pivot table
Hi Stephanie
You will find instructions here. http://www.contextures.com/xlPivot08.html But be aware, that you may not see the result as you expect. It would be better, if you could first combine all of your data to a single sheet (assuming your version of Excel can accommodate theta number of rows). For consolidating data from multiple sheets, take a look at http://www.rondebruin.nl/copy2.htm -- Regards Roger Govier Stephanie wrote: how do I do a pivot table with data that is on multiple worksheets? |
All times are GMT +1. The time now is 10:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com