Pivot table from sheet 1 and sheet 3

Replies to This Discussion

Permalink Reply by Allan Smallie on February 16, 2012 at 3:39am

Hi Allan,

I would look at combining Sheet1 and Sheet3. Alchemex will allow you to deliver both union reports to the same sheet!

Columns need to be the same, and in the same position - but this way, you are combining 2 sources of data.

The pivot can then run off Sheet1.

This what you are looking for?

• ▶ Reply

Permalink Reply by Dave Smith on February 18, 2012 at 3:49pm

Hi Allan, A Pivot does like to pull from one sheet, but you could have 2 pivots side by side on one sheet if your data is disparate.  Another thing to try is to push data to 1 & 3 & then write Excel formulas in the container to pull what you need from sheet 1 over to sheet 3 and then pivot off 3.  Remember to reference the Sheet name & named ranges in your formula.  

• ▶ Reply