Most valuable professional
  • 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:

  • Excel
  • Microsoft Excel