Excel2007 | I want to create a pivotTable from a different data, and different sheets

W

Waleed Assuty

Joined
Dec 22, 2014
Messages
1
Reaction score
0
Hello All
as i wrote in the title, :(
I have tow sheets with different data, and different Headers ! and i want to make a pivot table to summarize the data from the both of them !
as EXAMPLE
sheet 1 has the headers :
CONTRACT_LOCATION, QUOTE_ID, ACCOUNT_NAME, QUOTE_REGION.
and sheet2 has the headers
QUOTE_ID, SERVICE_CATALOG, SERVICE_NAME, SERVICE_LIST_PRICE.
the Quote_ID is the common field between the tow sheets , and all others is different!
i could do this in Excel 2013 using the new option Data Model , but i need to do it in 2007 as well ,
any help :confused:
thanks in advance ,
Regards
 

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

How to list cells from two sheets that has different values in theirneighboring column? 8
Copy Data from One sheet to Different Sheets 1
Custom Reporting Across Sheets 1
VBA Macro - Copying specific data to different sheets in a workbookand linking the InputBox to a com 7
Macro to Compile Data from Different Sheets 2
How to create a Pivottable with text only data 1
XML2Excel: Import to different sheets 2
How to hide password? 1

Top