Pivot table from diferent worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
Daniel,

You can use a ODBC UNION query with three parts to point to each of
the three different worksheets (I assume they've got the same
format). This makes the data appear as if it is coming from a single
source so far as the pivot table is concerned. It's a wee bit messy
to do but could probably be automated relatively easily with VBA.

Ian
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data table with inputs from a differente worksheet 1
Pivot Table Data Source 1
Pivot Table Update 3
Linking a pivot table filter to a control cell 2
Pivot Table date format 1
One pivot table for multiple worksheets/tabs 2
How can I write a reference formula? 2
Single Filter to change all Pivot Tables in a Workbook 8

Back
Top