create pivot table with master/detail data from 2 worksheets

B

BarbaraT

I am trying to create a report that combines master datat (Sales
Opportunities) with detailed history showing the date when various tasks
related to the Opportunities were completed. The data comes in two separate
exports to two worksheets - joined by a common id field. Any suggestions. I
tried the Consolidate process to create a cross tab but I don't want any of
the consolidate "summary functions" like sum or avg.
Thanks
 

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

Pivot Table from 2 worksheets 1
Pivot Table with source spread across multiple worksheets 1
combining data from multiple worksheets into one 6
Merging text cells from two worksheets with one shared column 3
How to compare and combine information from 2 different excelworksheets (VLOOKUP ? Pivot Table ?) 1
Macro to update pivot table data range 3
Filter Data From Master Sheet Into Other Worksheets 1
Combining data from multiple worksheets into master worksheet 1

Top