Single Pivot Table from multiple spreadsheets

  • Thread starter Thread starter John Foster
  • Start date Start date
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...
 
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
 
Back
Top