Jonathan M :
You actually just have a data formatting problem. You're using tabs to separate devices by departments instead of simply creating a department field/column and putting everything in one tab. The data was likely delivered to you that way, but don't let the delivery format define the true working format of the data.\n\nCombine everything in one tab, and then you'll be able to use the data in a pivot table just fine.\n\nIf you have more data than will fit in a tab, put it in a database such as MS Access, MS SQLServer or mySQL, and then tell excel to use the database as the pivot table source.",
2011-12-23T16:58:38
Doug Glancy :
I think Jonathan M has the best answer, but here's a way to do it using SQL that I've used successfully.",
2011-12-23T19:10:07
user359040 :
I don't know any easy way of doing this, but you could write a macro to copy and paste all your existing sheets onto a single new sheet (assuming there's enough room on a single sheet).",
2011-12-23T16:44:50
Jesse :
In 2007 Multiple Consolidated Ranges isn't in the default pivot table window. You need to create your pivot table, click on it, hit Alt + D, then P. Click back to step one and you'll have the option for multiple consolidated ranges.",
2011-12-23T17:29:12