Combine Data from 2 spreadsheets to create a single Pivot Table

S

Steved

Hello From Steved

I have 2 spreadsheets one is Called Auckland and the 2nd is Called Wellington.

My Objective please is to use the data from 2 spreadsheets to create a
single Pivot Table. Yes this is one workbook with 2 spreadsheets. is this
possible.

Thankyou.
 

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

Dealing with a Pivot Table (when I don't want to) 0
Excel does not accept text format! 0
Linking data in MS Word into Excel 5
Possible to Combine reports to's to a single box? 0
Automatic Macro to create 200 graphs 1
How to protect 2. axis in an Excel Chart to stay if data changes 0
Pivot Table - there is an error message pop out during creation. 1
multiple charts from a single pivot table 2

Top