A person named Fazza shows how on Mr Excel:

http://www.mrexcel.com/forum/showpos...58&postcount=3

I thought this was really cool, and now I'm incorporating it into a couple
projects.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Steved" wrote in message
...
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.