Pivot Table from several sheets

[MoMo1]

Hi,
I'm trying to create PT in Excel 2007 , the input for the PT should come from 2 sheets , the data in the sheets as the same headers ( the same # of col, same title name) .

I saw few answers , but I guess they were directed to Excel 2003 not 2007.

I know that the answer will be simple and obivious but I can;t fins it by myself.

 

[texasalynn]

Welcome to MrExcel Board . . .
take a look at these
http://office.microsoft.com/en-us/excel/HA102265851033.aspx
http://www.contextures.com/xlPivot08.html

that is a start and Jay Peltier also has some great info on pivot tables
http://www.peltiertech.com/

 

[MoMo1]

Hi texasalynn , the link is for Excel 2003, I don't have this criteria in 2007 , do u have the guide ness for 07 ?

 

[texasalynn]

I believe that Peliter link has 2007

edit:
looks like his URL has change
http://peltiertech.com/

 

[MoMo1]

Sorry , I couldn't find it
let me add some more information ,
in the "create Pivot Table " window , I have the following bullets :
1. Select a table or range
2.Use an external source

I'm using option #1

 

[texasalynn]

take a look at the external source and then browse for more and find your file. Then you will be given a list of the sheets to pick from. Sorry don't have alot of time to do the actual steps, but hopefully you will pick up from there

HTH

 

[MoMo1]

I'm sorry but I couldn't do it yet !
I followed your direction , I allocate the file in the external connection window , I can see a list of all my tabs but I can ONLY choose ONE tab ,
I'm lost !!!

 

[texasalynn]

well that's weird! I just tried in 2007 and it no longer seems to have that option. Looks like you would have to do a consolidation of all your sheets, then do a pivot table. I have just not had to do that in 2007 yet. It did work in lower versions. Thank you Microsoft

 

[MoMo1]

and I thought that I missing something ....
let me ask you differently , is there a way to create a sort of table from several worksheets ?
in each sheet I have rows that include month and amount ,
I want to be able to create consolidate table that take each month from the different tabs and sum the amount together

tab-x
month amount
0804 500

tab-y
month amount
0804 -300

consolidate
month amount
0804 200

 

[texasalynn]

if everything is in the exact same area then your could use

=SUM(Sheet2:Sheet3!C4:C11)