Single Pivot Table from multiple spreadsheets

J

John Foster

I am looking for a little advice as how to handle this situation best. I
have several Excel documents that I would like to summarize and put into a
Pivot Table. This is basically a timesheet summary utility. Our
organization uses an Excel template for our timesheets. I would like be
able to import a certain range of timsheets into a query or pivot table for
analysis and breakdown.

How can I best accomplish this?


thanks...
 
N

nobody

When going through the Pivot table wizard, choose multiple consolidation
ranges. This should also work with multiple workbooks as well as long as you
"show it" where these files are
 
Top