- Hot Topics
Excel Can I create a pivot table from two separate worksheets?
Hi, Say I have these sheets: Claims: CaseId 1 1 1 1 1 2 2 2 Payments: CaseId 1 1 1 2 Money: What I want in this sheet is a complex pivot table, or perhaps a complex VLOOKUP or array formula (???), with the data from these two separate worksheets. I'm not sure if I can do this in Excel or not? If I can do it in Excel, it would be cool as the end user gets immediate feedback/recalculations. Here is what I need:
This question generated 23 answers. To proceed to the answers, click here.
This thread is current as of January 6, 2014.
For more resources for Microsoft Excel:
This article includes the following tags:
- Microsoft Excel