Combine Data from 2 spreadsheets to create a single Pivot Table
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. |
Combine Data from 2 spreadsheets to create a single Pivot Table
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. |
Combine Data from 2 spreadsheets to create a single Pivot Tabl
Thankyou Jon
"Jon Peltier" wrote: 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. |
All times are GMT +1. The time now is 02:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com